AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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.
N978JSSerda Julie · Toledo, OHN9792DMoalli John · Friday Harbor, WAN9793ACoulter Robert · South Bend, INN9794ABurlace Thomas J III · Aurora, CON9795APatterson Roland O · Semmes, ALN9795DKennedy Gary R · Sanger, TXN9795MGaasch James F · Alpena, MIN9795TWhite Cap Aviation LLC · Amsterdam, NYN9795VWilliams Bob L · Udall, KSN9796DSki Ag Aviation LLC · Bismarck, NDN9797TBasham James L · Livingston, TXN9798ARupert Yuri · Lillian, ALFirst renewal noticeN9798TRegistered aircraftN9799TDeapen Jordan Derek · Clifton, TXN979JFGoodspeed Air Service LLC · Oxford, CTN97BBNix Terry W · Golden, MSN97JBVieira Nunes Da Silva Raphael · Ethel, LAN97KMSale Reported · Crystal, MNSale reportedN97KWShinas James M · Talkeetna, AKN97VXReinbird Thomas P · Wilson, NYN9800DHallada David A · Stanton, MIN9800JButts James Allen · Gainesville, GAN9800THerr Garrick D · Wasilla, AKN9801MUnderwood Mack C · Aiken, SCN98022Farmer Kenney · Milan, MIN98023Yellow Rose Cub Club LLC · Seabrook, TXN9802MBell Andrew J · Moultrie, GAN9802TSandford Graves M · Moberly, MON9803MJohnson Craig A · Moreland, GAN98040Bunger Glenn H · Kirkland, ILN9804ELorentzen John R · Port Alsworth, AKN9804JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLN9804TRussell Michael K · Sprakers, NYN9804YUnderwood Robert D · Randolph, NYN98054Craparo John S · Georgetown, TXN9805TNorman Ronald E · Lopez Island, WAN98081Knapp Frank E · Palmer, AKN9808TGilmer Randy G · Nickelsville, VAN9809JRies Roger W · Franklin, INN980FFairchild Argus LLC · Evergreen, CON980TAFierling Lennard W · Colton, ORN9810TWall Jeffrey L · Goffstown, NHN98118Tamarack Air Services LLC · Stevensville, MTN9811JJones Mark D · Corsicana, TXN98123Lazor Ronald E · Middlefield, CTN9812TBucks Flight Academy LLC · Cashion, OKN9813THenley Enterprises Inc · Mangonia Park, FLN9813YBlanshan Jay Victor · Alexandria, MNN9814TWickizer Stephen W · Knoxville, TNN98162Richmond Stephen C · Luthersville, GA
Back to AD 94-05-05 R1