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.

N512CSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2005 · S/N 3257396 N512DPCanal Aviation LLC · Dover, DEBuilt 2005 · S/N T18208420 N512EZCmtg Real Estate Enterprises Inc · Lakeland, FLBuilt 2005 · S/N 3257373 N5134BSalinas Four LLC · Salinas, CABuilt 2001 · S/N T18208103 N513HPVeracity Aviation LLC · Seguin, TXBuilt 2001 · S/N T20608285 N513VMMccabes Supply Inc · Watertown, NYBuilt 2004 · S/N T18208310 N5141YCommonwealth Of Virginia · Fort Monroe, VABuilt 2002 · S/N 18281077 N5143QMelnyk George · Sheridan, ORBuilt 2002 · S/N T18208108 N514CMHoward Darrell C · Lafayette, LABuilt 1972 · S/N 32-7240063 N5153GHeath Sean · Valley Center, CABuilt 2002 · S/N T18208114 N5156MRojas Jose Luis Gomez · Thermal, CABuilt 2002 · S/N T18208145 N5157ALongford Aviation Inc · West Chester, OHBuilt 2002 · S/N T20608350 N5157JApogee Finance LLC · Fort Worth, TXBuilt 1975 · S/N 340-0547 N5159QMdddk LLC · Wilmington, DEBuilt 2001 · S/N 3257211 N515DPBell Denise Augusta · Orlando, FLBuilt 2005 · S/N T18208430 N515LGN515lg Holding Inc · Wilmington, DEBuilt 1975 · S/N 31-7652001 N515PRDog Is My Copilot LLC · Polson, MTBuilt 1999 · S/N T20608020 N515TATomcat Aviation Inc · Tallahassee, FLBuilt 2003 · S/N 4636347 N5160YArnett Randall C · Anchorage, AKBuilt 2002 · S/N T18208117 N5164UElias Maria · El Paso, TXS/N T18208122 N5164XBlr Flyers LLC · Missoula, MTBuilt 2002 · S/N T18208123 N51651Terry Robert · Billings, MTBuilt 2002 · S/N T18208124 N5166HKeltz Brandon E · Montrose, COBuilt 2002 · S/N T18208125 N516ABRmp Corp · Pound Ridge, NYBuilt 1976 · S/N 32R-7680378 N516CLRimbeaux B C · Santa Fe, NMBuilt 2001 · S/N T20608288 N516DTCentral Airlines Inc · Overland Park, KSBuilt 1965 · S/N 1574 N516RSGenesee Air LLC · Wilmington, DEBuilt 1999 · S/N 4636208 N5170JArcher Aviation LLC · Traverse City, MIBuilt 2001 · S/N 3246189 N51710Mrizek Andrew J · San Jose, CABuilt 2002 · S/N T20608356 N5179BCorporate Flight Intl LLC · Glenwood Springs, COBuilt 2002 · S/N T18208137 N5179CPersonal Air Transportation Inc · Wilmington, DES/N 31-7401252 N517EASchafer Erich S · Fremont, MIBuilt 1975 · S/N 27-7554125 N517FDJoyner James M · Eagle River, AKBuilt 2001 · S/N 3257263 N51824US Department Of Homeland Security · Washington, DCBuilt 2003 · S/N T20608390 N51847Rippe Ryan · Fairbury, NEBuilt 2002 · S/N T20608363 N51849O'Ryan Air LLC · Wichita, KSBuilt 2002 · S/N T20608364 N5188BRegier Tom · Dinuba, CABuilt 2002 · S/N T18208141 N5190AArias Antonio · Lakeway, TXS/N T18208143 N5193MTar Pit Investments LLC · Austin, TXBuilt 2002 · S/N T18208146 N5198GConaway David L · Las Vegas, NVBuilt 2002 · S/N T18208150 N519CASakitumi LLC · Wilmington, DES/N 14239 N519MBThomas Andrea · Sacramento, CAS/N 27-0200 N519WATropeano Construction Inc · Belleview, FLBuilt 1970 · S/N 3081 N519WRTsmhta LLC · Indianapolis, INBuilt 2000 · S/N 4636259 N51GCCragg Gordon E · Georgetown, TXBuilt 1966 · S/N 27-3516 N51HPJ R'S Downwind Aviation Inc · Lantana, FLBuilt 1974 · S/N 27-7405412 N51KMBaker Leasing LLC · Kotzebue, AKBuilt 1973 · S/N 31-7305009 N51PGFly N' Fish LLC · Jacksonville, FLBuilt 1984 · S/N 32R-8529003 N5201SVancuren Maryann · Owasso, OKBuilt 1970 · S/N 32-40885 N5202SWilliams Christopher Lee · Wallingford, KYBuilt 1970 · S/N 32-40886

Back to AD 84-19-03 R1