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.

N41580Eagle Racer LLC · Boca Raton, FLBuilt 1994 · S/N 1809104 N41583Files Barbara E · Hopkinton, MABuilt 1974 · S/N 28-7415282 N41587Gary Deborah · Houston, TXBuilt 1994 · S/N 1809105 N4158DBoho LLC · Lewes, DEBuilt 1994 · S/N 1809087 N4158LJm Lavore Aero Inc · Lakeside, MTBuilt 1994 · S/N 1809100 N4158WButler John P · Hazelhurst, WIBuilt 1994 · S/N 1809102 N4158YAlliance Aircraft Sales Inc · Pierre, SDBuilt 1994 · S/N 1809103 N4158ZSchaetzel Paul Robert · New Meadows, IDBuilt 1965 · S/N 18-8340 N41593Flyin LLC · Hyde Park, UTS/N 28-7415286 N41594Butler John P · Hazelhurst, WIBuilt 1994 · S/N 1809113 N4159AHauser Associates Inc · Coral Gables, FLBuilt 1994 · S/N 1809106 N4159DBachman Aviation LLC · Independence, IAS/N 1809110 N4159PSparks Brian E · Monmouth, ORBuilt 1959 · S/N 23-1644 N4159SCrew Marshall D · Spokane, WABuilt 1994 · S/N 1809109 N4159XHagglund Carl D · Pendleton, ORS/N 341 N4159YBauer Aviation LLC · Reese, MIBuilt 1977 · S/N 23877 N415CAFly For Fun Aircraft LLC · Baltimore, MDS/N 2843215 N415CFAlo Fliteline Lc · Waterloo, IABuilt 1975 · S/N 28-7505118 N415GKCentral Clinton County Flying Club Inc · Jersey Shore, PABuilt 1982 · S/N 28-8290151 N415JBBrewer Allen E · Madison, MSBuilt 1999 · S/N 1463 N415MSNextgen Flight Academy Inc · Riverside, CABuilt 1978 · S/N 28-7816430 N415PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843448 N415RGalyon Aviation LLC · Sweetwater, TNBuilt 1958 · S/N TD-161 N415SGriffing Flying Service Inc · Port Clinton, OHBuilt 1978 · S/N 28-7990041 N41604Schuur Rodney E · Slayton, MNBuilt 1974 · S/N 28-7415290 N41606My Flight LLC · Cypress, TXS/N 287415291 N41609Worthington John F II · Russiaville, INBuilt 1974 · S/N 28-7405124 N4160JIvy James E · Alba, TXS/N 28-22489 N4160POgle Richard W Jr · Joplin, MOS/N 23-1645 N41614Cartier Edward J Jr · Columbia, MSS/N 28-7415294 N41618Evv Warrior LLC · Evansville, INBuilt 1974 · S/N 28-7415295 N41619Charles City Aeronautics Inc · Charles City, IABuilt 1974 · S/N 28-7415296 N4161JRegistration Pending · Hardinsburg, KYRegistration pendingBuilt 1966 · S/N 28-22490 N4161PRegistered aircraftBuilt 1999 · S/N 2843309 N41622Stingray LLC · Kalispell, MTBuilt 1974 · S/N 28-7415297 N41623Airplanesusa LLC · Schaumburg, ILBuilt 1974 · S/N 28-7405126 N4162YGarrels Gregory J · Salcha, AKBuilt 1977 · S/N 242-77 N41639Airmotive Service LLC · Brigham City, UTBuilt 1974 · S/N 28-7415299 N4163FHammans Gail A · Hot Springs, ARBuilt 1976 · S/N 28-7725003 N4163JLoera Josa · Laredo, TXS/N 28-22493 N41645Coastal Air Inc · Groton, CTBuilt 1974 · S/N 28-7405128 N41648Russell Matthew M · Niantic, CTBuilt 1974 · S/N 28-7415304 N41649Air Trek North LLC · South Saint Paul, MNBuilt 1974 · S/N 28-7415305 N4164JCaister Benjamin M · Saint Clair, MIS/N 28-22494 N4164PSeaplanes R Fun Inc · Wilmington, DEBuilt 1959 · S/N 23-1649 N41650Airmotive Service LLC · Brigham City, UTBuilt 1974 · S/N 28-7415306 N41657Morton Zac D · San Antonio, TXBuilt 1974 · S/N 28-7415308 N4165EJauer Brant A · Saukville, WIBuilt 1999 · S/N 2843291 N4165UInter American University Of Puerto Rico · Bayamon, PRBuilt 1998 · S/N 2843200 N4165ZHollingsworth Lloyd Dan · Anchorage, AKBuilt 1965 · S/N 18-8346

Back to AD 80-04-03 R2