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.

N510CCAwmr LLC · Conroe, TXBuilt 1978 · S/N 31-7812127 N510KCProcoff LLC · Shreveport, LABuilt 1993 · S/N 4622151 N511CABas Part Sales LLC · Greeley, COS/N 14035 N511HPPattison Aero Inc · Henderson, NVBuilt 2000 · S/N T20608251 N5127WRegistration Pending · Kalispell, MTRegistration pendingBuilt 2002 · S/N T20608360 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

Back to AD 91-21-01 R1