Skip to content

Registered aircraft · 68,375

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.

N32039Hedges Aviation Inc · Ronkonkoma, NYBuilt 1941 · S/N 5670 N3203FChampagne Anthony J · Prairieville, LABuilt 1967 · S/N 670123 N3203MDavid Dorin A · Kasilof, AKBuilt 1947 · S/N 12-1873 N32042Van Anda Aviation LLC · Apopka, FLBuilt 1974 · S/N 28-7515052 N32043Brolan Aviation LLC · Kansas City, MOBuilt 1974 · S/N 28-7515053 N32047Sat Aircraft LLC · Clermont, FLBuilt 1974 · S/N 28R-7535018 N32052Risley Bryan D · Bartow, FLBuilt 1974 · S/N 28-7525016 N32056Steuer Christopher · Plumas Lake, CABuilt 1974 · S/N 28-7515056 N32059Coast Property Inc · Nipomo, CABuilt 1974 · S/N 28-7505021 N3205BDurben Robert W · Newcomerstown, OHBuilt 1953 · S/N 22-2032 N3205FHawkins William J II · Saint Petersburg, FLS/N 680002 N3205JSchumacher Eraine · Hague, NDBuilt 1958 · S/N 1238 N32065Rare Aircraft Ltd · Faribault, MNBuilt 1941 · S/N 5697 N32066Chadwick Cobb Kristy L · Tallahassee, FLBuilt 1974 · S/N 28-7515059 N32067Legeros David · Brooklyn, NYS/N 28-7515060 N32068Christensen Gary L · Royal City, WABuilt 1974 · S/N 28-7515061 N32069Adb Investments LLC · Duncan, SCBuilt 1974 · S/N 28-7515062 N3206BNull Clifford M · Punxsutawney, PAS/N 22-2033 N3206EMorey Airplane Company Inc · Middleton, WIBuilt 1978 · S/N 17271467 N32070Williams Seth M · Jeanerette, LAFirst renewal noticeS/N 28-7505022 N3207EArmstrong Aviation LLC · New Orleans, LABuilt 1978 · S/N 17271468 N3207FGoodwin Winston L · Cypress, TXBuilt 1967 · S/N 670361 N3207PTraverse Air Inc · Traverse City, MIBuilt 1957 · S/N 23-1147 N3207RLingerfelt Joseph A · Woodburn, ORBuilt 1969 · S/N 28R-31129 N320827550g LLC · Birmingham, MIBuilt 1974 · S/N 28-7515065 N3208AKreitel Cody James · Anchorage, AKBuilt 1953 · S/N 25852 N3208BBallou Robert L · Puyallup, WABuilt 1953 · S/N 22-2035 N32095Rogers Dekishon W B · Atlanta, GABuilt 1974 · S/N 28-7525021 N32097Seniram Air Inc · Wilmington, DEBuilt 1975 · S/N 28-7515067 N32099Odland Steve E · Luverne, MNBuilt 1974 · S/N 28-7515068 N3209BDebuck Nathan J · Edgewood, NMS/N 22-2036 N3209PMg Renewal Corp Inc · Salt Lake City, UTFirst renewal noticeBuilt 1957 · S/N 23-1150 N320AGBusenbark Kenneth A · Niceville, FLBuilt 1991 · S/N 37032012614P2 N320AJDaedalus Wings Inc · Malvern, OHBuilt 2011 · S/N 77FB N320AKMclauchlin Todd · Sparks, NVBuilt 2001 · S/N 3841 N320BDDavis Burton D · Jefferson, IABuilt 2023 · S/N 906-320-747 N320BMSchenk Jonathan M · Amarillo, TXFirst renewal noticeBuilt 2019 · S/N 96M N320BSPriewe Steve R · Sardis, MSBuilt 2001 · S/N 357-320-115 N320BWWinterberg Brian D · Garberville, CABuilt 1997 · S/N 770-320-612FB N320CLSantiago Carlos M · Davis Junction, ILBuilt 2013 · S/N 002 N320CPPhilpott John C · Newbury Park, CABuilt 2015 · S/N 72661 N320DDBronson Robert D Trustee · Prineville, ORBuilt 1972 · S/N 17261193 N320DEMustang Aeronautics Inc · Chandler, AZBuilt 1991 · S/N 385 N320DHHedge Daniel A · Mabank, TXBuilt 2007 · S/N 98-1086 N320DJRegistration Pending · Beaufort, SCRegistration pendingS/N 249-320-17 N320DKOlsen Daniel M · Windsor, COS/N 363-320-SFB N320DPParr David A · Murray, UTS/N 707-320-551 N320DTCarroll Michael · Twinsburg, OHBuilt 2004 · S/N 20144 N320EDOday Shane C · Rose Hill, KSS/N 1288 N320ESBristol Peter W Sr · Punta Gorda, FLBuilt 2000 · S/N 859320701

Back to AD 90-04-06 R1