Skip to content

Registered aircraft · 5,102

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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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.

N506TMTall Timber Flying Service LLC · Kalispell, MTBuilt 2005 · S/N T20608585 N507JBDi Marco Michael G · Orlando, FLBuilt 1979 · S/N 27-7954051 N507MAAviation Consultants US Inc · Beaver Falls, PABuilt 2004 · S/N 3255014 N508ACKtaz Air LLC · Niceville, FLBuilt 2001 · S/N T18208012 N508YLally Michael M · Miami, FLBuilt 1969 · S/N 31-452 N50BFStephenson Keith · Studio City, CABuilt 2004 · S/N 4636355 N50CCScott Macdonald Aircraft Sales Inc · Stuart, FLBuilt 1974 · S/N 27-7405360 N50DJWest Chester Air LLC · West Chester, PABuilt 1981 · S/N 32-8124021 N50PSExecutive Airshares LLC · St Thomas, VIBuilt 1973 · S/N 31-7405165 N50RNOn Three Angels Wings LLC · Melbourne, FLBuilt 1983 · S/N 31P-8414013 N50VVVictor Victor Leasing LLC · Pompton Plains, NJBuilt 2004 · S/N T18208277 N5107YBrown Peter B · Salem, VABuilt 2001 · S/N T18208099 N510ADDj Aztec LLC · Springfield, OHBuilt 1980 · S/N 27-8054044 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

Back to AD 81-12-06 R1