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

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.

N1438DOlinde Aerospace LLC · Palm Bay, FLBuilt 1951 · S/N 20021 N1438FBermudez Santana Tacito O · Conyers, GAS/N 17254933 N1438YDr Luis S Navarro Pllc · Edinburg, TXS/N 17249138 N1439FHallock Lloyd E · Columbia, MOBuilt 1966 · S/N 17254934 N1439YGrace Aviation LLC · Fort Myers, FLBuilt 1962 · S/N 17249139 N143AKLipinski Glen E · Chandler, AZS/N 15074168 N143DGSowela Technical Community College · Lake Charles, LABuilt 2010 · S/N 16200029 N143RUpson Theodore C · Newport, NYBuilt 1947 · S/N 11-1520 N1440GSierra-Mike LLC · Springdale, ARS/N 15072955 N1440QN1440q LLC · Maybee, MIS/N 15072740 N1441FMartin Michal R · Alva, OKBuilt 1966 · S/N 17254936 N1441HHolder Jimmy R · North Pole, AKS/N 15AC-506 N1441NAir Tractor West Inc · San Joaquin, CABuilt 1947 · S/N 22971 N1441QSale Reported · Franklin, INSale reportedBuilt 1971 · S/N 15072741 N1442BWilliams Michael · Hartsville, INBuilt 1948 · S/N 6069 N1442QDelaware Aviation LLC · Sidney, NYFirst renewal noticeBuilt 1971 · S/N 15072742 N1443FNelson Harold G · Pendleton, ORBuilt 1966 · S/N 17254938 N1444BPoklar Norman · Mount Orab, OHS/N 6071 N1444FStrope Byron P · Upland, CABuilt 1966 · S/N 17254939 N1444HHaugan James A · Two Harbors, MNS/N 15AC-511 N1444QPelco Aviation Inc · Hampton Bays, NYBuilt 1971 · S/N 15072744 N1444YHiggins Derrick G · Arbyrd, MOBuilt 1962 · S/N 17249144 N1445FMorris Loyd Albert · Alvarado, TXBuilt 1966 · S/N 17254940 N1445YSwartz Steven L · Nashville, TNBuilt 1962 · S/N 17249145 N1446QBeek Dudley Ernest · Miami, FLFirst renewal noticeS/N 15072746 N1446YWise Ron · Napoleon, OHBuilt 1962 · S/N 17249146 N1447BSmith Shawn Benjamin · Salem, ORBuilt 1948 · S/N 6074 N1447DSimmons Dennis L · Wichita, KSS/N 20030 N1447FCook David F · Carthage, MOBuilt 1966 · S/N 17254942 N1448BCook David L Trustee · Owasso, OKBuilt 1948 · S/N 6075 N1448HWilder Jon R Jr · Glenfield, NYBuilt 1950 · S/N 15AC-517 N1448QWjs Aircraft LLC · New Smyrna Beach, FLBuilt 1971 · S/N 15072748 N14499Cox Alex E · Watson, ARFirst renewal noticeBuilt 1948 · S/N 7DC42 N1449BZander Walter W · Glendora, CABuilt 1948 · S/N 6076 N1449FJanes Brenda · Shepherdsville, KYBuilt 1966 · S/N 17254944 N1449QAero Maintenance Inc · Vancouver, WABuilt 1971 · S/N 15072749 N144ARPaone Rebecca L · South Rockwood, MIS/N 28267 N144CRFrantz David L · Manchester, TNFirst renewal noticeBuilt 1973 · S/N 15075438 N144ELubeck Thomas L · Anchorage, AKBuilt 1974 · S/N F-013 N144PWAerowood Aviation LLC · Monroe, NCBuilt 1965 · S/N 17254019 N144WDDaugherty Warren F Jr · Jonestown, PABuilt 2022 · S/N 187 N1450HSoltis Francis J · Chugiak, AKBuilt 1950 · S/N 15AC-519 N1450YMalmkar Shannon T · Grant, NEBuilt 1962 · S/N 17249150 N1451FCloud Busters Inc · Summertown, TNBuilt 1966 · S/N 17254946 N1452FHorizon Aviation LLC · Bristow, OKBuilt 1966 · S/N 17254947 N1452HWilliams Saul C · Fairbanks, AKBuilt 1950 · S/N 15AC-521 N1452YBuranen Mark · Wilmington, DEBuilt 1962 · S/N 17249152 N1453BManning Jerry C · Lufkin, TXBuilt 1948 · S/N 6080 N1453YNava Henry · Santa Ana, CABuilt 1962 · S/N 17249153 N1454BWithrow Thomas E · Lewisburg, WVS/N 6081

Back to AD 94-05-05 R1