Skip to content

Registered aircraft · 40,396

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

N5420WGade Donald A · Antioch, ILS/N 28-491 N54214Halo Aviation Texas LLC · Fredericksburg, TXBuilt 1981 · S/N 17274922 N54219Kleb John S · Aurora, ILBuilt 1981 · S/N 17274925 N5421KWings Over Texas Holdings LLC · Denton, TXS/N 17274104 N5421LStanfill Michael O · Lucedale, MSS/N AA5-0321 N5421WBrown David A · Olympia, WAFirst renewal noticeBuilt 1962 · S/N 28-492 N54223Woodworth Brent J · Halliday, NDBuilt 1976 · S/N 18-7609045 N5422QMandeville James R · Bridgewater, MABuilt 1989 · S/N 111 N5422SVanwagnen Brian J · Jackson, MIBuilt 1971 · S/N 28-7125118 N54233Wenke Donald S · Big Lake, AKBuilt 1976 · S/N 18-7609047 N5423ESkywarrior Flight Training LLC · Pensacola, FLBuilt 1978 · S/N 17271854 N5423JRialto Christian Flyers Club Inc · Bradenton, FLBuilt 1980 · S/N 17273787 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

Back to AD 79-10-03 R2