AD 97-01-13
Registered aircraft · 54,837
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N172WWStraight And Level Seaplanes LLC · Grand Island, FLN172XPTrapp Thomas A · Salem, CTN172XXRoberts Christopher B · Warner Robins, GAFirst renewal noticeN172YNewton Michael R · Creston, WAN172YACf Images LLC · Fairfield, NJN172YHWild River Flying Club · Saint Croix Falls, WIN172YYApr Aviation · Fresno, CAN172ZMoss Mark A · El Dorado, CAN172ZGSouthern Aircraft Consultancy Inc Trustee · Casper, WYN1730FSpragues Aerial Spraying Inc · Courtenay, NDN1730ZLoftis Kenneth L · Phoenix, AZN1731FHostetler Robert J · Windyville, MON1732FWicks Colton D · Cooper, TXN1732MCarey International Aviation Services LLC · Long Beach, NYN1732RHeath William D Jr · Bremen, GAN1732VElk & Ram Aviation Group LLC · San Antonio, TXN1733FRegistered aircraftN1733RNorthstar Holdings LLC · Anchorage, AKN1734FWlb Farms LLC · Iota, LAN1734XRight Wing Left Wing Flyers LLC · Cleveland, GAN1735ERsc Ventures LLC · Phoenix, AZN1735MG & M Aircraft Inc · Wheat Ridge, CON1735QMadden David · Bethlehem, NHN1736CThompson Frank L · Weiser, IDN1737High Flight Academy LLC · Allison Park, PAN17371Lynch Kyle R · Palmetto, FLN17375Jts Aircraft LLC · Rock Hill, SCN1737CBristol Brian P · Webster, MNN1737EKeystone Aerial Surveys Inc · Philadelphia, PAN1737FVoltl Mike N · Coloma, WIN1737MClinton Aviation Corp · Clinton, ARN1737QWilliams Kamille N · Juneau, AKN1737RMorales Richard · Palm Springs, CAN1737VWatson Patrick D · Kenyon, MNN17382Hagelstein Ele C · Sanderson, TXRegistration expired, pending cancellationN1738FWesley Emerson Holdings LLC · Clifton, TXN1739COpp Daniel · Anchorage, AKN1739FSessions Jan · Kirbyville, TXN173BADunlap Jolene · Peoria, ILN173KADaigle Lawrence J · Cohasset, MNN173KMLd Enterprises Llp · Roswell, GAN173LLRegistration Pending · Barrigada, GURegistration pendingN173MCCiochetti Michael J Jr · Clayton, GAN173PKTrc-4k Investments LLC · Southlake, TXN173RGBuchert Christine W · SchweinfurtN173SKS Kamat Inc · Lexington, KYN173VALegner Leasing LLC · Las Vegas, NVN173VFCorlee Douglas K · Palm Coast, FLN173VRDauria William · Anna, TXN173YAHoekman Kenneth J · Sherwood, AR
Back to AD 97-01-13