Skip to content

Registered aircraft · 56,580

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-14-R1') 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-14-R1') 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-14-R1')
    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-14-R1')
  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-14-R1')
  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-14-R1')
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.

N2954YFasano Garth · Boulder, COBuilt 1962 · S/N 18253954 N29552Montgomery Skyhawk LLC · Bethesda, MDBuilt 1974 · S/N 17264118 N29554Eagle Sky Patrol · Deadwood, SDBuilt 1968 · S/N 17700960 N2955DWalsh David E · North Platte, NEBuilt 1955 · S/N 26898 N2955FBoyd John W · Milton, WABuilt 1966 · S/N 18257055 N2955JAguilar Honorio Alejandro · Anna, TXBuilt 1966 · S/N 15065755 N2955YAda Forestry Division · Malvern, ARBuilt 1962 · S/N 18253955 N29563Brown Winn D Jr · Horn Lake, MSBuilt 1968 · S/N 17700966 N2956JDecker Kathy A · Greenville, MIBuilt 1966 · S/N 15065756 N2956SPuder Karen D · Lenzburg, ILBuilt 1967 · S/N 15066856 N2956UMitchell Casey D · Lucedale, MSBuilt 1963 · S/N 17250556 N2956YRegistration Pending · Wilmington, DERegistration pendingBuilt 1962 · S/N 18253956 N2957CCurrier Dustan · Fairbanks, AKS/N 30857 N2957JMcmahon Thomas G · Hoffman Estates, ILBuilt 1966 · S/N 15065757 N2957KSutton Aircraft Salvage LLC · Palmer, AKBuilt 1980 · S/N 18053138 N29581Bas Part Sales LLC · Greeley, COBuilt 1968 · S/N 17700972 N29584Eagle Sky Patrol Inc · Deadwood, SDBuilt 1968 · S/N 17700974 N29585Ramold Corey M · Gretna, NEBuilt 1968 · S/N 17700975 N2958CSale Reported · Anchorage, AKSale reportedBuilt 1954 · S/N 30858 N2958KPionair Inc · ChamBuilt 1980 · S/N 18053139 N2958XCooper Ronald C · Fowlerville, MIBuilt 1968 · S/N 17700358 N29592Reyner Matthew J · Georgetown, TXBuilt 1968 · S/N 17700978 N29593Else John J · Toledo, IABuilt 1968 · S/N 17700979 N29595Delta Fox Corp · Schaumburg, ILBuilt 1968 · S/N 17700980 N29596Murray Charles W · Reno, NVBuilt 1968 · S/N 17700981 N2959DWatson Frank H · Central Point, ORBuilt 1955 · S/N 26902 N2959JJones Eugene B Jr · Pflugerville, TXBuilt 1966 · S/N 15065759 N2959SCobb Patricia J Trustee · North Las Vegas, NVS/N 15066859 N2959XCiochetti David · Kimberly, ORBuilt 1967 · S/N 17700359 N295FAStationair Amphib LLC · Jefferson City, MOBuilt 1980 · S/N U20605482 N295GTMedina-Solla Edwin O · Carolina, PRBuilt 1966 · S/N 18257799 N295LPWildridge Aviation LLC · Layton, UTBuilt 2003 · S/N 172S9295 N295MEWings Air Charter LLC · Wisconsin Rapids, WIBuilt 2000 · S/N 172S8553 N295PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2022 · S/N 172S12871 N295PLAerospring Leasing LLC DBA · Wasilla, AKBuilt 2023 · S/N 172S13018 N295TFTextron Aviation Inc · Wichita, KSS/N 172S13621 N295THHowser Anthony J · Batavia, OHS/N 15072736 N2960AGallman Alexander C · Livingston, TXBuilt 1953 · S/N 30160 N2960JGlinsky Edward Jr · Rhome, TXBuilt 1966 · S/N 15065760 N2960SDewitt Daniel · Camarillo, CABuilt 1967 · S/N 15066860 N2960UMedford Mark A · Mantua, OHBuilt 1963 · S/N 17250560 N29617Abbott Barry · Tempe, AZS/N 17700994 N29619Loudenslager Donald F · Collinsville, OKBuilt 1968 · S/N 17700996 N2961AMerrill Richard C · Chuckey, TNBuilt 1953 · S/N 30161 N2961DWilliwaw Ventures LLC · Anchorage, AKBuilt 1955 · S/N 26904 N2961FNilssen Carl J · Cameron, WIBuilt 1966 · S/N 18257061 N2961SInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 15066861 N2961XLaurina Peter · Knoxville, TNBuilt 1967 · S/N 17700361 N2961YGarcia Kale B · Covington, WABuilt 1962 · S/N 18253961 N29625Sale Reported · Fort Myers, FLSale reportedBuilt 1968 · S/N 17700998

Back to AD 79-10-14 R1