Skip to content

Registered aircraft · 5,075

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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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.

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 N9244YParker Aircraft Sales Inc · Wilmington, DEBuilt 1983 · S/N 31P-8414014 N9245YMiles Aviation LLC · Sheridan, WYBuilt 1983 · S/N 31P-8414025 N9246MShenkirsch Consulting Inc · Mammoth Lakes, CABuilt 1993 · S/N 4622149 N9246PSharp Paul C · Modesto, CABuilt 1967 · S/N 24-4745 N9247LGenesis Aviation Enterprises Inc · Fort Lauderdale, FLS/N 31-8152160 N9247PEhrenberg David G · Corning, NYBuilt 1968 · S/N 24-4746 N9247YWest Bend Air Inc · West Bend, WIBuilt 1968 · S/N 31-322 N9248PPajaro Jaison · Burtonsville, MDBuilt 1966 · S/N 24-4627 N924CCSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1966 · S/N 27-3490 N924DCAirmann Leasing LLC · Mount Sterling, KYBuilt 1996 · S/N 4636057 N924RRHigh Timothy Duane · Glenwood, MOBuilt 1977 · S/N 32R-7780450

Back to AD 84-19-03 R1