Skip to content

Registered aircraft · 20,687

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

N75866Gibson Aviation Services LLC · Menomonie, WIBuilt 1976 · S/N 17268009 N75871Blue Wing Flyer LLC · Marietta, GABuilt 1977 · S/N 17268011 N75874Walled Lake Flying Club · Waterford, MIBuilt 1976 · S/N 17268012 N75876Roe Amber · Scotts Valley, CABuilt 1976 · S/N 17268013 N75878Milosevich Nikola · Deland, FLBuilt 1976 · S/N 17268014 N75879Griffin Aviation LLC · Spokane, WABuilt 1976 · S/N 17268015 N7587TStreater Stephen · Palm Coast, FLBuilt 1959 · S/N 47187 N7587XBrown Bomber LLC · Missoula, MTS/N 17248087 N75885Mds Enterprises LLC · Lemont Furnace, PABuilt 1976 · S/N 17268019 N7588TSale Reported · Orlando, FLSale reported, pending cancellationBuilt 1960 · S/N 47188 N75890Milligan Tony L · Rumford, MEBuilt 1976 · S/N 17268020 N75897Gopalakrishnan Sanjeev K · Spring, TXBuilt 1976 · S/N 17268023 N75898Center O Flying Club · Tumwater, WABuilt 1976 · S/N 17268024 N7589DBergstrom Aircraft Inc · Pasco, WABuilt 1979 · S/N 17272927 N758CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12726 N75904Worley Dan L · Heber Springs, ARS/N 17268028 N75907Rmb Leasing Inc · Dover, DEBuilt 1976 · S/N 17268031 N75909Martin Michael J · Anchorage, AKS/N 17268033 N7590TDauteuil Rodney A · Salem, NHBuilt 1959 · S/N 47190 N75917Abs Aviation · Lanham, MDBuilt 1976 · S/N 17268040 N7591GRochez Gerald A · Jensen Beach, FLBuilt 1970 · S/N 17259291 N7591TScamman Glenn O · Topeka, KSBuilt 1960 · S/N 47191 N75922Phillips Lester L · Pahrump, NVBuilt 1976 · S/N 17268045 N75925A&A Aviation LLC · Edinburgh, INBuilt 1976 · S/N 17268047 N75926Owens Flight Training LLC · Lafayette, LABuilt 1976 · S/N 17268048 N7592TSouthern Kentucky Aviation LLC · Bowling Green, KYS/N 47192 N75930Rivera Aniceto · Boonton, NJBuilt 1976 · S/N 17268052 N75931Alston Russell R · South Jordan, UTS/N 17268053 N75938Fiedler Aviation LLC · Suffolk, VABuilt 1976 · S/N 17268055 N7593EFrench Robert J · Ferndale, WABuilt 1978 · S/N 17272113 N7593XMills Laura L · Canton, OHBuilt 1960 · S/N 17248093 N75942Ward Sharon A · Lago Vista, TXBuilt 1976 · S/N 17268058 N75943Savage Island Airport (Vt15) LLC · Burlington, VTBuilt 1976 · S/N 17268059 N75944Noll Gregory Lloyd · Watford City, NDBuilt 1976 · S/N 17268060 N7594TGrimes Arthur D · Zeeland, MIBuilt 1959 · S/N 47194 N75950West John T · Bulverde, TXBuilt 1976 · S/N 17268063 N75951Newman James D · El Cajon, CAS/N 17268064 N75955Belgarde Monte G · Butte, MTBuilt 1976 · S/N 17268067 N75956Millennium Aviation Group LLC · Wallace, NCBuilt 1976 · S/N 17268068 N7595XDelgado Mario Jr · Baldwin Park, CAS/N 17248095 N75967Ace Of Spades Aviation LLC · Las Vegas, NVBuilt 1976 · S/N 17268073 N7596XBurklund Joel · Minneapolis, MNBuilt 1960 · S/N 17248096 N75971Price Ronald Anthony · Deer Park, WABuilt 1976 · S/N 17268075 N75972Aircraft Resource Center Inc · Lakeville, MNBuilt 1976 · S/N 17268076 N75974733et LLC · Columbus, OHS/N 17268077 N75976Suburban Aircraft Leasing And Sales LLC · Sylvania, OHBuilt 1976 · S/N 17268079 N75982Schurr Frank J · Las Vegas, NVBuilt 1976 · S/N 17268083 N75985Pitt Patrick L · Ephrata, WABuilt 1976 · S/N 17268086 N7598GGbc Leasing LLC · Gun Barrel City, TXBuilt 1970 · S/N 17259298 N7598TFieldgrove Matt L · Somerton, AZS/N 47198

Back to AD 90-06-03 R1