Skip to content

Registered aircraft · 68,369

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:90-04-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:90-04-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:90-04-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:90-04-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:90-04-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:90-04-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.

N2042CDms Leasing Co LLC · Las Vegas, NVS/N TD-219 N2042QKachemak Bay Flying Service Inc · Temple, TXBuilt 1975 · S/N 17265453 N2043Precision Aero LLC · Wilmington, DEBuilt 1998 · S/N 28008C N20430Jets To Helis LLC DBA · Chandler, AZBuilt 1989 · S/N 1236 N20431Organization Of Black Aerospace Professionals · Westchester, ILBuilt 1972 · S/N 17261283 N20437Wingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17261287 N20439Wilken Virginia · Sequim, WABuilt 1972 · S/N 17261289 N2043CLouisiana Community And Technical College System · New Iberia, LABuilt 2008 · S/N 0329 N2043HMont Belvieu Materials Inc · Mont Belvieu, TXBuilt 1946 · S/N 7AC-4302 N2043LBrown Dennis · Moncks Corner, SCBuilt 1976 · S/N M-1856 N2043MPaxton Flyers · Loda, ILBuilt 1977 · S/N 28-7816241 N2043QAnderson Michael R · Bedford, INBuilt 1973 · S/N 177RG0443 N2043RBoltjes Thomas S · Platte, SDBuilt 1969 · S/N 28-5441 N20442Young Thomas E · Smithsburg, MDBuilt 1939 · S/N 1130 N20443Walker Martha D · Auburndale, FLBuilt 1972 · S/N 17261291 N20445Norman Chuck DBA · Zanesville, OHBuilt 1972 · S/N 17261293 N20447Jensen James A · Palo, IABuilt 1939 · S/N 1135 N20449J2 Aero LLC · Ringgold, GABuilt 2008 · S/N 0330 N2044DMyalik Gennady K · Campobello, SCS/N 0116 N2044LLeitner Jay T · Hurst, TXBuilt 1976 · S/N MC-440 N2044MDowling Michael L · Adrian, MIBuilt 1977 · S/N 28-7816242 N2044QWhite Sound International Ltd · New Smyrna Beach, FLBuilt 1973 · S/N 177RG0444 N2045Fox Wayne G · Belle Mead, NJBuilt 1972 · S/N 1A N20451Registration Pending · Swainsboro, GARegistration pendingBuilt 1972 · S/N 17261297 N20452Bay Flying Services LLC · Pinconning, MIBuilt 1972 · S/N 17261298 N20454Rl Aviation LLC · Miami, FLBuilt 1972 · S/N 17261300 N20455Kachemak Bay Flying Service Inc · Temple, TXBuilt 1972 · S/N 17261301 N20457Gulf Atlantic Airways Inc · Gainesville, FLBuilt 1972 · S/N 17261303 N2045NChristensen Tyler R · Red Bluff, CABuilt 1958 · S/N 186771 N204648231 Tango Enterprises LLC · Guthrie, OKBuilt 1972 · S/N 17261308 N20465C Flyers Inc · Dyersville, IABuilt 1972 · S/N 17261309 N2046CTexflight LLC · Beaumont, TXBuilt 2001 · S/N 0127 N2046LRegistration Pending · Bonham, TXRegistration pendingBuilt 1976 · S/N MC-433 N2046RBiser Group LLC · Huntington, WVBuilt 1969 · S/N 28-5443 N20470Dameron Cleveland Forrester · Wicomico Church, VABuilt 1972 · S/N 17261313 N20471Cp Aircraft Leasing LLC · Danville, CABuilt 1972 · S/N 17261314 N20472N20472 LLC · Opa Locka, FLBuilt 1972 · S/N 17261315 N20474Voinovich John · Ogden, UTBuilt 1972 · S/N 17261317 N2047ABig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-899 N2047ESeaside Cycles Inc · Johns Island, SCBuilt 1978 · S/N 17271131 N2047QMeersma Montgomery D · Atlanta, GABuilt 1973 · S/N 177RG0447 N20481Lesage Robert E · Puyallup, WABuilt 1973 · S/N 17261324 N20484North Central Aircraft Sales · Tioga, NDBuilt 1973 · S/N 17261327 N20486Humbert Delmar Alan · Briones, CABuilt 1973 · S/N 17261329 N20487Point To Point Air LLC · Arlington, WAS/N 17261330 N20488Aurora 17 Holdings LLC · Aurora, ORBuilt 1973 · S/N 17261331 N2048ABig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-904 N2048LDp Network LLC · Coconut Creek, FLBuilt 1976 · S/N M-1857 N2048MMiller Gerald L · Selinsgrove, PABuilt 1977 · S/N 28-7816244 N20490Aarow Aircraft Leasing LLC · Mcminnville, ORS/N 17261333

Back to AD 90-04-06 R1