Skip to content

Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.

N91AUScreaming Duck Air LLC · Houston, TXS/N 32R-8129017 N91BPF3 Aviation LLC · Summerville, SCBuilt 1977 · S/N 31-7812034 N91BRRegistration Pending · South Boston, VARegistration pendingBuilt 1965 · S/N 24-4326 N91FBAircraft Partner Holdings Inc Trustee · BerlinBuilt 2003 · S/N 3257314 N91MKMulaii LLC · Wilmington, DEBuilt 2014 · S/N 4636647 N9200PWings & Wheels Lease Of Central Nebraska LLC · Broken Bow, NEBuilt 1967 · S/N 24-4693 N9202YRomeo Aviation Ltd · Canton, OHBuilt 1983 · S/N 31P-8414004 N9205PDt Pralle Enterprise Inc · Hampton, IAS/N 24-4700 N9207PWissler John H · Tenino, WABuilt 1967 · S/N 24-4702 N9210YOswald Sean B Trustee · Reno, NVBuilt 1983 · S/N 31P-8414007 N9211PBordeleau Michael V · Bridport, VTS/N 24-4706 N9212PHapka Leon J · Halma, MNFirst renewal noticeBuilt 1967 · S/N 24-4707 N9212YS & B Foundation Air LLC · Auburn, ALBuilt 1983 · S/N 31P-8414008 N9214HJem Aviation Ltd · Wilmington, DEBuilt 1990 · S/N 4622114 N9215YAstro Star Aviation Inc · Niles, MIBuilt 1968 · S/N 31-279 N9216PWilliams Dayre · Red Cloud, NEBuilt 1967 · S/N 24-4712 N9218YHubble Boeing Development Corp · Gallipolis, OHBuilt 1968 · S/N 31-282 N9219PChrastka Keith · San Angelo, TXBuilt 1967 · S/N 24-4715 N921CBDavis David G · Cresson, TXFirst renewal noticeBuilt 1980 · S/N 32R-8129019 N921JBC&Z Aero LLC · Des Plaines, ILBuilt 1976 · S/N 32R-7780099 N921UN921un Ventures LLC · Mercer Island, WABuilt 2004 · S/N T20608501 N9220PDavid Rever Aviation LLC · Dewey Beach, DEBuilt 1967 · S/N 24-4716 N9221PStevenson Tom · Portland, ORBuilt 1967 · S/N 24-4718 N9222PAztec Remains LLC · Potosi, WIBuilt 1967 · S/N 24-4719 N9224PAnde Leasing Co LLC · Edgewood, NMS/N 24-4721 N9224YFavret Bernard A · Ocean Springs, MSBuilt 1983 · S/N 31P-8414012 N9225PRegistered aircraftBuilt 1967 · S/N 24-4722 N9225YDodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N 31P-8414015 N9226KAlatis Nicholas C · Cincinnati, OHBuilt 1976 · S/N 32R-7680199 N9227PSiebold Peter · Tehachapi, CABuilt 1967 · S/N 24-4717 N9228PShillig Vance R · Colorado Springs, COS/N 24-4726 N9229PKoeman Scott B · Fort Moore, GAS/N 24-4727 N922BSCentral Airlines Inc · Leawood, KSBuilt 1966 · S/N 1598-207 N922JMApplied Aerospace Concepts Pllc · Bloomington, MNBuilt 1972 · S/N 24-5017 N922MJAga Aviation LLC · Woodruff, SCBuilt 1997 · S/N 3257004 N9231PSeaton Flying Services Inc · Salado, TXBuilt 1967 · S/N 24-4729 N9231YBbees LLC · Moss Point, MSBuilt 1983 · S/N 31P-8414017 N9233PBlandina Leon V · New Hudson, MIBuilt 1967 · S/N 24-4731 N9235PJen Lyn Inc · Wilmington, DEFirst renewal noticeBuilt 1967 · S/N 24-4734 N9235YKamasano LLC · Highland, CABuilt 1983 · S/N 31P-8414020 N9236PTasso Aviation LLC · Orrville, ALS/N 24-4735 N9237PCloud Climibers LLC · Lexington, KYBuilt 1967 · S/N 24-4736 N9238PPylant Eric Jon · Arnold, CABuilt 1967 · S/N 24-4737 N9238WMansour Muhamad A · Wichita, KSBuilt 1967 · S/N 28-10908 N9239YDelgado John F · San Antonio, TXBuilt 1984 · S/N 31P-8414040 N923JSSankey Aviation LLC · Warminster, PABuilt 2005 · S/N T18208390 N923SDFresno County Sheriffs Department · Fresno, CABuilt 2001 · S/N T20608342 N9241PGaskill Jeffrey V · Weston, MOS/N 24-4740 N9242PDekervor Marc Phillippe II · La Mesa, CAS/N 24-4741 N9243PKanne Michael J · Des Moines, IABuilt 1967 · S/N 24-4742

Back to AD 91-21-01 R1