Registered aircraft · 56,578

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.

N13939Diessner Daniel J · New Smyrna Beach, FLBuilt 1976 · S/N 17702477 N1393EMossler Jonathan E · Edgewater, FLBuilt 1978 · S/N 17270983 N1393FBenham John D · Blanco, TXBuilt 1975 · S/N 18502840 N1393QBeitel Ronald Lee · Rochester, MNBuilt 1971 · S/N 15072693 N1393USelim Shahir P · Hollywood, FLBuilt 1976 · S/N 17267064 N1393YHall Bret C · West Plains, MOBuilt 1962 · S/N 17249093 N13941Wings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263044 N13942Rohrer Mary · Fredericksburg, TXBuilt 1974 · S/N 17263045 N13943Tell Christopher A · Colville, WAS/N 17263046 N13944Ripp Ted · Pulaski, TNBuilt 1974 · S/N 17263047 N13946Air Capital Aviators Club · Wichita, KSBuilt 1974 · S/N 17263048 N1394FWeller Fred R · Saint Augustine, FLBuilt 1966 · S/N 17254889 N1394QDaugherty Keith C · Venus, PABuilt 1971 · S/N 15072694 N1394SGoodman Donald J · Bellingham, WABuilt 1976 · S/N 18264955 N1395EHendricks Paul · Yellville, ARBuilt 1978 · S/N 17270984 N1395SGarcia Robert W · Floresville, TXFirst renewal noticeS/N 18264956 N1395UBentley Robert H · Lockport, ILBuilt 1976 · S/N 17267066 N1395YEisele William Robert · Alt Loma, CABuilt 1961 · S/N 17249095 N1396DFlying Dutchman Aviation LLC · Richmond, TXBuilt 1951 · S/N 19972 N1396YGarrison Shannon · Pangburn, ARS/N 17249096 N13974Total Prf LLC · New Smyrna Beach, FLBuilt 2006 · S/N 172S10409 N1397MRichs Inc · Wilmington, DES/N 21061940 N1397SKnotty Aviation LLC · Fort Myers, FLBuilt 1976 · S/N 18264958 N1397URock Solid Aviation LLC · Lake Charles, LABuilt 1976 · S/N 17267068 N1397YMeyer Richard L · Fort Wayne, INBuilt 1961 · S/N 17249097 N13986Euro 2000 Inc · Merritt Island, FLBuilt 2008 · S/N 17281503 N1398CBennett Eric · Warsaw, INBuilt 1977 · S/N 17702720 N1398EMichael Elan · Encino, CABuilt 1978 · S/N 17270985 N1398SOff The Charts LLC · Kalispell, MTBuilt 1976 · S/N 18264959 N1399MRegistered aircraftBuilt 1975 · S/N 18264314 N1399SDesmond Brett Kyle · Mars, PABuilt 1976 · S/N 18264960 N1399UOc 172 Group LLC · Costa Mesa, CAFirst renewal noticeBuilt 1976 · S/N 17267070 N139ARSky West Aviation Inc Trustee · Albuquerque, NMS/N 25557 N139BBTrejo Nahomy · Socorro, TXBuilt 1979 · S/N 21063712 N139BTTaylor Edward S · Billings, MTBuilt 1957 · S/N 29707 N139ERRick Aviation Inc · Newport News, VABuilt 1985 · S/N 17276532 N139METotal Flight Aircraft Leasing LLC · Apex, NCBuilt 2000 · S/N 172S8423 N139RABeach Cruisers LLC · Ormond Beach, FLBuilt 1999 · S/N 18280614 N139SAMississippi Forestry Commission · Pearl, MSBuilt 2003 · S/N 20608195 N139TWMcghee James Allen · Houston, TXBuilt 2002 · S/N 172S9139 N139UDAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11488 N13BALong Arthur · Colonie, NYBuilt 1975 · S/N 15077300 N13BBGoodwin William W · Pleasureville, KYBuilt 1949 · S/N 15234 N13BJSevcik Clint · Medford, MNS/N 21058486 N13CBT&W Aviation LLC · Pinehurst, TXBuilt 1981 · S/N 17274805 N13DRSchuler Edward A Jr · Hamden, CTFirst renewal noticeBuilt 1966 · S/N 15064816 N13DSR & M Adventures LLC · Wichita, KSBuilt 1980 · S/N 18267798 N13EFMcgough Julie Eileen · Red Oak, TXBuilt 1967 · S/N 337-0794 N13FGBaum Group LLC · Shavertown, PABuilt 1957 · S/N 34271 N13FTFenix Private Capital Group LLC · Phoenix, AZS/N P3370245

Back to AD 79-10-14 R1