Skip to content

Registered aircraft · 4,469

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

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-20-04-R2') 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-20-04-R2') ORDER BY n_number

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-20-04-R2')
    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-20-04-R2')
  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-20-04-R2')
  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-20-04-R2')
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.

N8318NAir Power Associates LLC · O Fallon, MOBuilt 1968 · S/N D-8723 N8320DMiller Mark A · Hutchinson, MNBuilt 1958 · S/N D-5437 N8321NAstle John K · Brighton, MIBuilt 1968 · S/N D-8722 N8322DTupelo Aeronautics Inc · Tupelo, MSS/N D-5459 N8323DRegistered aircraftBuilt 1957 · S/N D-5405 N8324DLacour Erik · Clovis, CABuilt 1958 · S/N D-5426 N8325NKontour Shawn K · Wheatland, WYBuilt 1968 · S/N D-8730 N8326DSchulte Allison R · Trappe, MDBuilt 1958 · S/N D-5442 N8326NLimitless Experience Inc · Middletown, DEBuilt 1968 · S/N D-8728 N8327DLeavitt John C · Titusville, FLBuilt 1957 · S/N D-5411 N8328N789 Aviation LLC · Medina, OHBuilt 1968 · S/N D-8735 N8330DV-Tail Flyers Inc · Chanhassen, MNBuilt 1958 · S/N D-5483 N8331DLee John M · Lakebay, WABuilt 1958 · S/N D-5537 N8332NMoon Kai LLC · Laguna Niguel, CABuilt 1968 · S/N D-8740 N8333DRegistration Pending · Tibubon, CARegistration pendingBuilt 1958 · S/N D-5434 N8334DDykes Robert W · Knoxville, TNBuilt 1958 · S/N D-5435 N8336NDejong James D · Doon, IABuilt 1968 · S/N D-8737 N8337NLivesay Gregory K · Mckinney, TXBuilt 1968 · S/N D-8739 N8339NMekolik Aaron S · College Station, TXBuilt 1968 · S/N D-8746 N8342DTexas Logos LLC · Lometa, TXBuilt 1958 · S/N D-5487 N8343NWavra Mark F · East Grand Forks, MNBuilt 1968 · S/N D-8741 N8346DRegistered aircraftBuilt 1958 · S/N D-5447 N8348DSanders Tyler A · Austin, TXBuilt 1958 · S/N D-5461 N8349DSorenson Steve A · Cody, WYBuilt 1958 · S/N D-5441 N834TMStoelt William L · Lynden, WABuilt 1964 · S/N D-7433 N8350DBas Part Sales LLC · Greeley, COBuilt 1958 · S/N D-5444 N8351DDotson Eric E · Wagoner, OKBuilt 1958 · S/N D-5433 N8353NLindahl Jonathan · Cary, ILBuilt 1968 · S/N D-8756 N8356NNielson Frederick P · Mesquite, NVS/N D-8744 N8357DQuinn Robert F · San Mateo, CABuilt 1958 · S/N D-5470 N8358DAskelson Eldon L · Meridian, IDBuilt 1958 · S/N D-5524 N8358NQuam Contracting LLC · Creston, IAS/N D-8751 N8359NHendricks Flying Service LLC · Imperial, NEBuilt 1968 · S/N D-8753 N835BBusigin Tikhon · Ocala, FLBuilt 1958 · S/N D-5508 N8360DSanders Dean L Trustee · Nordland, WABuilt 1958 · S/N D-5481 N8360NYost Rawson · Watertown, SDBuilt 1968 · S/N D-8755 N8361DRiker Richard · East Falmouth, MABuilt 1958 · S/N D-5471 N8364DElliott Areospace LLC · Kalispell, MTBuilt 1958 · S/N D-5475 N8366DPage Howard G · Burlingame, CABuilt 1958 · S/N D-5485 N8367DAg-Monkey Inc · Norris City, ILBuilt 1958 · S/N D-5474 N8367NSearch Septic · Bailey, COBuilt 1968 · S/N D-8749 N8369DPalmer Paul H · Marshall, TXBuilt 1958 · S/N D-5493 N836RCoates Stephen T · Roseville, CABuilt 1959 · S/N D-6252 N8370DJones Richard P · Mukilteo, WABuilt 1958 · S/N D-5463 N8371NDecision Air Corp · Wilmington, DEFirst renewal noticeBuilt 1968 · S/N D-8758 N8372DBuford Phillip N · Bethesda, DCBuilt 1958 · S/N D-5492 N8372NRudolph Pam G Trustee · Lake Havasu City, AZBuilt 1968 · S/N D-8759 N8374DGlick John D · Longmont, COBuilt 1958 · S/N D-5478 N8375DBoucher Kenneth G · Scotland, CTBuilt 1958 · S/N D-5480 N8378NBowler Joseph · Inglis, FLBuilt 1968 · S/N D-8760

Back to AD 94-20-04 R2