Skip to content

Registered aircraft · 40,472

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N31SCObryant Jeffrey A · Fairbanks, AKBuilt 1967 · S/N 79 N31THNet Air Co · Monroe, MIBuilt 1979 · S/N AA5B1142 N31TJAdams Ian B · Laramie, WYBuilt 2002 · S/N 60414 N31VGTita Enterprises LLC · Apex, NCBuilt 2004 · S/N 3551 N31VHAmy Inc · Wilmington, DEBuilt 2005 · S/N 3966 N31VSJenny Timothy J · Remsen, NYBuilt 1999 · S/N 1273-99 N31VTSnediker Daniel G · Pittsburgh, PABuilt 1966 · S/N 28-3208 N31WBBaker James P · Brighton, COBuilt 1995 · S/N 22470 N31WGFleischman James H · Remus, MIBuilt 1990 · S/N 1951 N31WTThomas Norman W · Forest, VABuilt 1980 · S/N 172RG0291 N31YBritton Stephen D · Delhi, LABuilt 1957 · S/N TD-41 N31ZRRusso R Michael · Pipersville, PABuilt 2004 · S/N 23093 N32004Priceless Pleasures LLC · Jordan, MNBuilt 1974 · S/N 28-7515044 N32008K L M Aircraft Co · Media, PABuilt 1974 · S/N 28-7505014 N3200ERegistration Pending · Burlington, WIRegistration pendingBuilt 1978 · S/N 17271466 N3200GSpinner Family Limited Partnership · White City, ORBuilt 1956 · S/N 22-4042 N3200MPride Jesse D · Eagle River, AKS/N 12-1872 N3200ZBrady Michael E · Buffalo, NYBuilt 1959 · S/N 22-7140 N32019Spicher Samuel Charles · Harrisonburg, VABuilt 1974 · S/N 28-7505017 N3201ZMcclain William J · Corona, CABuilt 1959 · S/N 22-7141 N3202SCramer Traci · Hatfield, PABuilt 1996 · S/N 1111S N32030Robert Starr · Schofield, WIBuilt 1974 · S/N 28-7515048 N3203FChampagne Anthony J · Prairieville, LABuilt 1967 · S/N 670123 N32042Van Anda Aviation LLC · Apopka, FLBuilt 1974 · S/N 28-7515052 N32043Brolan Aviation LLC · Kansas City, MOBuilt 1974 · S/N 28-7515053 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 N3205JSchumacher Eraine · Hague, NDBuilt 1958 · S/N 1238 N32066Chadwick Cobb Kristy L · Tallahassee, FLBuilt 1974 · S/N 28-7515059 N32067Legeros David · Brooklyn, NYS/N 28-7515060 N32069Adb Investments LLC · Duncan, SCBuilt 1974 · S/N 28-7515062 N3206EMorey Airplane Company Inc · Middleton, WIBuilt 1978 · S/N 17271467 N32070Williams Seth M · Jeanerette, LAFirst renewal noticeS/N 28-7505022 N3207PTraverse Air Inc · Traverse City, MIBuilt 1957 · S/N 23-1147 N320827550g LLC · Birmingham, MIBuilt 1974 · S/N 28-7515065 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 N3209PMg Renewal Corp Inc · Salt Lake City, UTFirst renewal noticeBuilt 1957 · S/N 23-1150 N320AGBusenbark Kenneth A · Niceville, FLBuilt 1991 · S/N 37032012614P2 N320AKMclauchlin Todd · Sparks, NVBuilt 2001 · S/N 3841 N320CLSantiago Carlos M · Davis Junction, ILBuilt 2013 · S/N 002 N320DDBronson Robert D Trustee · Prineville, ORBuilt 1972 · S/N 17261193 N320DJRegistration Pending · Beaufort, SCRegistration pendingS/N 249-320-17 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 N320JAMalsack Joseph A · Merrill, WIS/N 292-320-54

Back to AD 80-04-03 R2