Skip to content

Registered aircraft · 26,231

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-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

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.

N16120Av8 Flight Assets LLC · Eden Prairie, MNBuilt 1972 · S/N 15073491 N16125Palmer Earl S Jr · Boise, IDBuilt 1972 · S/N 15073494 N16127Skypark Inc · Wadsworth, OHBuilt 1972 · S/N 15073496 N16128Marquette County Flying Club · Marquette, MIBuilt 1972 · S/N 15073497 N16129Rankin Kevin · Maryville, MOBuilt 1972 · S/N 15073498 N1612NHoffman Conrad · Madison, SDBuilt 1947 · S/N 410 N1612VQuan Justin · Ventura, CABuilt 1947 · S/N 13784 N1613Registered aircraftBuilt 1969 · S/N 384 N1613FAde William Henry III Trustee · Tucson, AZBuilt 1966 · S/N 17255008 N1613NSage Terry L · Tyler, TXFirst renewal noticeBuilt 1947 · S/N 431 N1613YNelson Bobby E · Lago Vista, TXS/N 17249313 N1614FMathena Chad R · Narrows, VABuilt 1966 · S/N 17255009 N1615FWells Edmund B · Austin, MNBuilt 1966 · S/N 17255010 N16165Registered aircraftBuilt 1972 · S/N 15073514 N16166Hayden Scott M · Walworth, WIBuilt 1972 · S/N 15073515 N16169Trotter Patrick J · North Las Vegas, NVBuilt 1972 · S/N 15073518 N1616DCorbin Sarah R · Anchorage, AKFirst renewal noticeBuilt 1951 · S/N 20258 N1616ELundquist Brian · Ankeny, IABuilt 1946 · S/N 7AC-5181 N1616FMarciel John L · John Day, ORBuilt 1966 · S/N 17255011 N1616NSaari Michael J · Sycamore, ILBuilt 1947 · S/N 402 N1616QKrehbiel Bradley C · Lake City, MNS/N 15072916 N16174Cirrostrats Inc · Deland, FLBuilt 1972 · S/N 15073523 N16177Norby Aviation LLC · Hopkinton, MABuilt 1972 · S/N 15073525 N16179Farrell Donald A · Owasso, OKBuilt 1972 · S/N 15073527 N1617NTippit Larry J · Grand Prairie, TXS/N 403 N1617QAljanabi Mohammed Khalid · Herndon, VAS/N 15072917 N16180Last Mango Air LLC · Fond Du Lac, WIBuilt 1972 · S/N 15073528 N16184Finkel David M · Shelbyville, INS/N 15073530 N1618DJutting Anthony C · Fruitland, IDS/N 20260 N1618FCastillo Giovanny G · Brodheadsville, PAS/N 17255013 N1618NDeshl-Air Flying Club · Custar, OHBuilt 1947 · S/N 404 N16194Booth Jesse R · Alamosa, COBuilt 1972 · S/N 15073537 N16196Macdonald Kaitlyn A · Dillon, MTBuilt 1972 · S/N 15073539 N1619DVintage Pacific Aviator LLC · Redondo Beach, CABuilt 1951 · S/N 20261 N1619FReeve Howard E · Minot, NDS/N 17255014 N1619QAmos Carl R · Chandler, INBuilt 1971 · S/N 15072919 N1619VCushway Amos · Anchorage, AKS/N 13791 N161APT3 Aerosports LLC · Vian, OKFirst renewal noticeBuilt 1964 · S/N 17251383 N161LHJackson Donald R · Lexington Park, MDBuilt 1966 · S/N A161 N161SReliant Air LLC · Nashua, NHBuilt 1946 · S/N 1074 N161WLCrestair Air LLC · Dover, DEBuilt 2006 · S/N 161004 N16202Steward Charles M · Tuttle, OKS/N 15073543 N16206Schultz Aviation Services LLC · Crowley, LABuilt 1972 · S/N 15073544 N16207Martinez Jose Antonio · Orlando, FLBuilt 1972 · S/N 15073545 N16210Simpson Dean H · Limon, COBuilt 1972 · S/N 15073546 N16216Scott Jeffrey A · Camden, TNBuilt 1972 · S/N 15073549 N1621DPease Rex A · Grand Haven, MIBuilt 1951 · S/N 20263 N1621FDimtroff John P · Issaquah, WABuilt 1966 · S/N 17255016 N16221Aero Maintenance Inc · Vancouver, WABuilt 1972 · S/N 15073553 N16222Thumser Douglas Francis · Newcastle, CABuilt 1972 · S/N 15073554

Back to AD 94-05-05 R1