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.

N4190VAtp Aircraft 2 LLC · Wilmington, DEBuilt 1998 · S/N 17280626 N41912Eastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280628 N4191FN4191f LLC · Kingsland, TXBuilt 1958 · S/N 46091 N4191LKelsey James R Sr · La Plata, MOS/N 17254260 N4192FDavidson E Bryant Trustee · Owasso, OKBuilt 1958 · S/N 46092 N4192VMerren Trennon R · Brady, TXBuilt 1948 · S/N 18525 N4193LJaybird Flight LLC · Mesa, AZBuilt 1966 · S/N 17254262 N4193RHunter Jeffrey Jay · Shreveport, LABuilt 1998 · S/N 17280636 N4193YVan Dorpe Ross · Saint Charles, ILBuilt 1998 · S/N 18280359 N4194QJacques Jerry J · Iliamna, AKS/N U2061359 N4194WNicholson Jon S · Bethel, AKBuilt 1967 · S/N 1851203 N4195EHusky Central LLC · Hugo, OKBuilt 1998 · S/N 18280363 N4195FDavolt John W · Hobe Sound, FLS/N 46095 N4195RPlain LLC · Traverse City, MIBuilt 1998 · S/N 18280364 N4196DCub Club Incdba · Fort Myers, FLBuilt 1999 · S/N 18280461 N4196FLabrie David L · Deland, FLBuilt 1958 · S/N 46096 N4196GProuse Craig H · Groveland, CABuilt 1998 · S/N 18280367 N4197FFrizzell Joshua R · Mcdonough, GABuilt 1958 · S/N 46097 N4197QSumner Properties LLC · Somersworth, NHBuilt 1998 · S/N 18280370 N4197VBaker Air Service Inc · Baker, MTS/N 18530 N4197XBarr Air Patrol LLC · Mesquite, TXBuilt 1999 · S/N 18280449 N4198UMay David E · West Liberty, KYBuilt 1963 · S/N 15060198 N4199FPena Edwin A · Mission Hills, CABuilt 1958 · S/N 46099 N4199LSarkisian Arthur · Woodstock, GABuilt 1966 · S/N 17254268 N4199TEnga James Craig · Madison, SDBuilt 1998 · S/N 18280372 N4199UTailwind Aviation LLC · Stafford, KSBuilt 1963 · S/N 15060199 N419AKeech Paul A · Fairbanks, AKBuilt 1953 · S/N 25702 N419BEVolar La Vida LLC · Kalispell, MTBuilt 1968 · S/N 18259409 N419CALind William · Los Angeles, CAS/N 15069273 N419CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12348 N419CSGarza Richard · Monterey, CABuilt 2016 · S/N 18282419 N419EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2019 · S/N 172S12278 N419FRAtp Aircraft 8 LLC · Wilmington, DEBuilt 2014 · S/N 172S11446 N419JARaw Aviation LLC · Wichita, KSBuilt 2007 · S/N 18281885 N419LKSluka Christopher · San Diego, CABuilt 1978 · S/N 17271787 N419SFTotal Flight Aircraft Leasing LLC · Apex, NCS/N 17262659 N41ARobertson Roy E · Marion, IABuilt 1978 · S/N 21062798 N41AFAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1965 · S/N 17253102 N41AMStephens Calvin · Adrian, GABuilt 1974 · S/N 17262980 N41APRising Wings Aviation Inc · Casper, WYBuilt 1977 · S/N 17268890 N41BXWilliams Paul E · Kendallville, INBuilt 1981 · S/N 18053197 N41CEWhats Up Doc Aviation LLC · Alexander, ARBuilt 1978 · S/N 21062872 N41CHLaperle Brian D · Colebrook, NHBuilt 1956 · S/N 32319 N41DLLdair Inc · Roanoke, VABuilt 2002 · S/N 18281142 N41EMBretscher Mark · Hinsdale, ILBuilt 1976 · S/N 177RG0923 N41FAKingsky Flight Academy LLC · Lakeland, FLBuilt 1979 · S/N 17272997 N41GCAviation Of North Florida LLC · Jacksonville, FLBuilt 1956 · S/N 33612 N41GVRbs Inc · Wht Sphr Spgs, WVBuilt 1977 · S/N 18265837 N41JCKiddink LLC · Wilmington, DES/N 18267036 N41MCGarner John B · Newark, DEBuilt 1984 · S/N 18268379

Back to AD 79-10-14 R1