Skip to content

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.

N5423KRandel James B III · Mill Valley, CABuilt 1980 · S/N 17274105 N54247Registration Pending · Melbourne, FLRegistration pendingBuilt 1976 · S/N 18-7609049 N5424JFusano Lisa A · La Crescenta, CABuilt 1980 · S/N 17273788 N5424QBeltzville Aero LLC · Lehighton, PABuilt 1973 · S/N 17261787 N5424SNeely Benson W · Florence, MSBuilt 1971 · S/N 28-7125119 N54257Meridian Airport Authority · Meridian, MSBuilt 1981 · S/N 17274932 N5425LHamilton Paul DBA · Fresno, TXBuilt 1973 · S/N AA5-0325 N5425MWong Alex · Hillsborough, CABuilt 1978 · S/N M-2026 N5425WIrmen Walter Michael Jr · Arlington Heights, ILS/N 28-497 N5425YWilson Leif L · Tok, AKBuilt 1964 · S/N 18-8177 N54266Low Country Skyways LLC · Wilmington, DEBuilt 1989 · S/N 5-18-42 N5426FPressley Aviation LLC · New London, NCBuilt 1976 · S/N 28-7715132 N5426JMedia Stew LLC · Carson City, NVS/N 17273789 N5426MWorthington Aras · Anchorage, AKS/N 001 N5426QLen Emery Photography LLC · Springfield, VTBuilt 1973 · S/N 17261789 N54273Swanson Gary A · Fort Bragg, CABuilt 1981 · S/N 17274938 N5427FRebel Aviation Inc · Liberty, MOBuilt 1976 · S/N 28-7715133 N54283Sale Reported · Lewistown, MTSale reportedBuilt 1975 · S/N 18-7509130 N54285Monahan Richard J Jr · Budd Lake, NJBuilt 1981 · S/N 17274945 N54288Chandler Air Service Inc · Chandler, AZBuilt 1981 · S/N 17274946 N5428FSchold Maury W · Stafford Springs, CTBuilt 1977 · S/N 28-7790118 N5428WBon Investment Holdings LLC · Zephyrhills, FLBuilt 1962 · S/N 28-500 N54290Laguna Verde Leasing Inc · Wilmington, DEBuilt 1981 · S/N 17274948 N54291Flight School Of Gwinnett Inc · Lawrenceville, GABuilt 1981 · S/N 17274949 N54296Honcho Aircraft LLC · Crosby, TXBuilt 1981 · S/N 17274950 N5429FQuick Kenneth C Jr · Burke, VABuilt 1976 · S/N 28-7790119 N5429LGardner T Larry · Dickson, TNS/N AA5-0502 N5429WLafontaine Generator Exchange Inc · La Fontaine, INBuilt 1962 · S/N 28-501 N542FCooper Nina · Lake Elmo, MNBuilt 2022 · S/N 542 N542FLHaffey George F · Fernandina Beach, FLBuilt 1971 · S/N 28-7125374 N542MADaystar Aviation LLC · Orange Park, FLS/N 28-7816364 N54306Aiken Patrick J · West Greenwich, RIBuilt 1981 · S/N 17274951 N5430FUnion Aviation LLC · El Dorado, ARBuilt 1976 · S/N 28-7790120 N5430LKanarick Justin · Colleyville, TXBuilt 1973 · S/N AA5-0330 N5430WAnderson Douglas S · Gansevoort, NYS/N 28-503 N54311Daniel Earl F · Ashland, KYBuilt 1981 · S/N 17274952 N54319Jones Roddy H · Thomasville, GABuilt 1981 · S/N 17274954 N5431WBig Daddys Casino Inc · Huntington, WVBuilt 1962 · S/N 28-506 N54322Myers Robert E · Sperry, OKBuilt 1981 · S/N 17274956 N54324T2xb LLC · Valdosta, GABuilt 1981 · S/N 17274958 N5432EMilwaukee Aero LLC · Milwaukee, WIBuilt 1978 · S/N 17271860 N5432HArmstrong Aviation Services LLC · Freeport, PABuilt 1975 · S/N 17265432 N5432LPlanesworld LLC · Jasper, GABuilt 1973 · S/N AA5-0332 N5432WVantilborg Craig S · Minot, NDBuilt 1962 · S/N 28-507 N5433EAty Aviation Inc · Watertown, SDBuilt 1978 · S/N 17271861 N5433LGray Sarah M · Boulder Creek, CABuilt 1973 · S/N AA5-0333 N5433PStephens Matthew T · Ocean Springs, MSBuilt 1958 · S/N 24-487 N54346Aviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1981 · S/N 17274959 N5434DSierra Lima Aviation LLC · Riverton, UTBuilt 1979 · S/N 17272569 N5434EMiller Shane D · Cherokee, OKBuilt 1978 · S/N 17271862

Back to AD 80-04-03 R2