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.

N16199Allbritton John Mark Trustee · Oakland, TNBuilt 1976 · S/N 17702493 N161AMDe Boissard Karen · New York, NYS/N 2161 N161AWAir Ward Inc · Columbia, CABuilt 1979 · S/N 28-8016078 N161BGWilson James R · Midlothian, VABuilt 1978 · S/N 287816527 N161DERegistered aircraftBuilt 1977 · S/N 28-7816295 N161GTYellow Jacket Flying Club Inc · Atlanta, GABuilt 1986 · S/N 17276650 N161JLLuebben John R · Fayetteville, GABuilt 1966 · S/N 346 N161KMParis Air Inc · Vero Beach, FLBuilt 1977 · S/N 28-7716136 N161MBKerf 25 Corp · Wilmington, DEBuilt 1982 · S/N 28-8216163 N161PTPilot Training Center LLC · Miami, FLBuilt 1989 · S/N 2841156 N161SMMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 28-7916508 N161SWLober Cameron K · Matthews, NCBuilt 1966 · S/N 28-3752 N162Payne David J · Eagle River, AKBuilt 1957 · S/N 22-5677 N1620ABeaver David W Trustee · Wasilla, AKBuilt 1952 · S/N 18-1263 N1620PNielsen Mona · Ford, WABuilt 1954 · S/N 22-2434 N16244Oakland William S · New Port Richey, FLBuilt 1973 · S/N 28-7305211 N162505b Aviation LLC · Duncan, OKBuilt 1973 · S/N 28-7305212 N16252Robbins Warren N · Chandler, AZBuilt 1973 · S/N 28-7305213 N16257Chauvet Nicolas · North Kingstown, RIBuilt 1973 · S/N 28-7305216 N1625GPippert Jim · Dysart, IABuilt 1968 · S/N 127 N1625JCain Philip K · Escondido, CABuilt 1968 · S/N 28-24818 N1625PGauthier Robert Jones · Melba, IDBuilt 1954 · S/N 22-2439 N1626JLawrence Gavin · Borger, TXBuilt 1967 · S/N 28-24013 N1627APlettner David C · Sutton, NEBuilt 1951 · S/N 18-1267 N1627EWichterman George J Trustee · Fort Myers, FLBuilt 1978 · S/N 17271070 N1627HCirrus Services Inc · Fargo, NDBuilt 1977 · S/N 28-7716028 N1627PMiller Wesley M · Crookston, MNBuilt 1954 · S/N 22-2441 N16283Winn Philip P · Salem, OHBuilt 1973 · S/N 28-7325231 N16284Rocco Jeffrey M · Carson, CABuilt 1969 · S/N 28-26015 N16288Bailey Brent M · Dalzell, SCBuilt 1973 · S/N 28-7325234 N16289Williams Kevin L · Buchanan, TNBuilt 1973 · S/N 28-7325235 N1629EAnson Air LLC · Sugar Land, TXBuilt 1978 · S/N 17271072 N1629JBuckley Barney P · Colfax, WABuilt 1967 · S/N 28-24016 N162ACWatson Tommy R · Thibodaux, LABuilt 1997 · S/N 1235-97 N162ASA S Air LLC · Lantana, FLBuilt 1978 · S/N 17271785 N162BCRegistration Pending · Tampa, FLRegistration pendingBuilt 2004 · S/N 465-2004 N162DSDavid Y Stevens · Falcon, COBuilt 2009 · S/N 90695 N162GMMiltenberger Roger J · Sergeant Bluff, IABuilt 1990 · S/N 162 N162KMerge Mafia LLC · Wall, TXBuilt 1959 · S/N 18-7171 N162RVAcord John R · Hattiesburg, MSBuilt 2004 · S/N 23143 N162WTFly Whiskey Tango 2 LLC · Scottsdale, AZBuilt 1984 · S/N 17276202 N16304Stockmeier Steven J · Liberty Twp, OHBuilt 1973 · S/N 28-7325237 N16305Fross James B · Wichita, KSBuilt 1973 · S/N 28-7305221 N1630JPiston Aviation LLC · Saint Charles, MOBuilt 1967 · S/N 28-24017 N1630PSmith Richard D · Williamstown, OHBuilt 1954 · S/N 22-2444 N16317Wolf Aviation Network Inc · Westfield, MABuilt 1973 · S/N 28-7325223 N16318Enbom Brian Trustee · Discovery Bay, CABuilt 1973 · S/N 28-7325241 N16319Bethers Michael R · New Market, MDBuilt 1973 · S/N 28-7305224 N1631ESkywarrior Flight Training LLC · Pensacola, FLBuilt 1978 · S/N 17271073 N1631JReds Aircraft LLC · Edinburg, TXBuilt 1969 · S/N 28-25416

Back to AD 80-04-03 R2