Registered aircraft · 40,473

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.

N6225RHartman Michael F · Montclair, CABuilt 1979 · S/N 172RG0122 N6226JXigent Aviation Inc · Wilmington, DEBuilt 1976 · S/N 28-7690375 N6226WN6226w Inc · Solon, IABuilt 1964 · S/N 28-20267 N6227RMidwestern Soaring Assoc · Peculiar, MOBuilt 1965 · S/N 15061527 N6227UVan Tilborg Dale W · Abilene, TXBuilt 1962 · S/N 2249 N62281Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275242 N62287Glidewell Aviation Inc · Parkland, FLBuilt 1981 · S/N 17275247 N6228KSunset Leasing Inc · Sarasota, FLBuilt 1980 · S/N 17274175 N6228WKoshan Kathryn E · Edgewater, FLBuilt 1964 · S/N 28-20270 N62296Sale Reported · Signal Hill, CASale reportedS/N 17275249 N6229UMonte Sam A · Bend, ORBuilt 1962 · S/N 2068 N622APCaradine Jimmie · Commerce, TXFirst renewal noticeBuilt 1969 · S/N 15071086 N622CAKlovning Jason John · Platteville, WIBuilt 1959 · S/N 24-1292 N622CFTxpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 2104 N622DLColorado Aircraft Corp · Watkins, COBuilt 1975 · S/N 17264853 N622EHaggerty Russell P · Bethpage, NYBuilt 1971 · S/N 17260059 N622EXErdman Jeffery L Sr · Montague, MIBuilt 2021 · S/N JA1611101 N622FLMontgomery Lauryn A · Minor Hill, TNBuilt 1971 · S/N 28-7125509 N622FTReese William A · New Smyrna Beach, FLBuilt 1991 · S/N 10022 N622GPTwenty Two Ashford LLC · Brentwood, TNBuilt 1981 · S/N 17274593 N622JBSun Aircraft Management LLC · Ormond Beach, FLBuilt 1978 · S/N 44-7995080 N622KSSpears Jason M · Milton, WVBuilt 1994 · S/N 622ES N622NL1st American Aviation Inc · North Miami, FLS/N 0386 N622SAParker Helicopter LLC · Watsonville, CABuilt 2005 · S/N 3912 N6230DUsda Aphis Wildlife Services · Cedar City, UTBuilt 1979 · S/N 17272648 N6230URutter Bruce W · Ralph, MIBuilt 1962 · S/N 2069 N6231EMiller Edward P · Northfield, MNBuilt 1978 · S/N 17272001 N6231FH & F Aviation Inc · Labelle, FLS/N 17273170 N6231HCandace A Larned Enterprises Inc · Long Beach, CABuilt 1977 · S/N 28-7816238 N6231WMission Air LLC · Oklahoma City, OKBuilt 1964 · S/N 28-20271 N6232DJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17272650 N6232WN6232w LLC · Rushland, PABuilt 1964 · S/N 28-20272 N62332Skylens LLC · Hammond, LABuilt 1981 · S/N 17275251 N6233DGrauert Ritter Trustee · Van Nuys, CAS/N 17272651 N62348Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 17275254 N6234CSchilling Aviation Services LLC · Salina, KSBuilt 1978 · S/N 28-7890349 N6234JLane Jerry P · Grinnell, IABuilt 1976 · S/N 28-7615339 N6234LHenderson Cathy H · Gordon, TXBuilt 1993 · S/N 1949 N6234UNabert Maher K · Augusta, GABuilt 1962 · S/N 2073 N6234VAnderas Per R · Green Bay, WIBuilt 1993 · S/N 2156 N6234WDahlenburg Tory L · Smyrna, TNBuilt 1964 · S/N 28-20275 N62350Flycarolina LLC · Concord, NCBuilt 1981 · S/N 17275255 N62354Skywarrior Flight Training Inc · Pensacola, FLBuilt 1981 · S/N 17275256 N6235HAirworthyone LLC · Caledonia, MIBuilt 1977 · S/N 28-7890219 N6235JFrost Aviation Services Inc · Las Cruces, NMBuilt 1976 · S/N 28-7615341 N62367Nehl Seth M · Mandan, NDS/N 18-4334 N6236JArcher N6236j LLC · Denver, COBuilt 1976 · S/N 28-7690377 N6236WBjornstad John · Maple Grove, MNS/N 28-20278 N6237JHulett Michael · Saginaw, MOBuilt 1976 · S/N 28-7690378 N6237UCardoza Roger A · Fairbanks, AKBuilt 1962 · S/N 2076

Back to AD 80-04-03 R2