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.

N330JEWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280299 N330MEUnique Educational Experiences · Signal Hill, CABuilt 2000 · S/N 172S8462 N330PMPractical Education LLC · New York, NYBuilt 2008 · S/N 172S10809 N3310RSeitz Martin V · Brookfield, WIBuilt 1967 · S/N 18258610 N3310TFly448 LLC · Wausau, WIBuilt 1968 · S/N 17700045 N3310YRegistration Pending · Fayetteville, ARRegistration pendingS/N 18254310 N3311DPendergrass Joseph M · Wasilla, AKBuilt 1955 · S/N 32109 N3311RView From Above Inc · Columbia, CABuilt 1967 · S/N 18258611 N3311SExperimental Aircraft Association Inc · Oshkosh, WIBuilt 1969 · S/N 21059111 N3311TSchulze Tom L · Smithville, MOBuilt 1967 · S/N 17700611 N3311UBeck Gary · Albuquerque, NMBuilt 1963 · S/N 18254711 N3311YChavez Rafael J · Santa Fe, NMBuilt 1962 · S/N 18254311 N3312FWill Robert J · Fall City, WABuilt 1966 · S/N 18257312 N3312JAlternate Air Inc · Seattle, WABuilt 1966 · S/N 15066012 N3312RParish Mark · Earth, TXBuilt 1967 · S/N 18258612 N3312SBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 21059112 N3312URoberts Air Inc · Goodwin, ARBuilt 1963 · S/N 18254712 N3313JEsckelson Eric S · Cass City, MIS/N 15066013 N3313ULayton Robert H · Seminole, TXBuilt 1963 · S/N 18254713 N3313VAviation Enterprises Inc · Springfield, MOBuilt 1974 · S/N 15076457 N3313YCosta Flying Service Inc · Painted Post, NYS/N 18254313 N3314EEnglund Frances L · Fairport, NYBuilt 1978 · S/N 17271500 N3314SN3314s LLC · Oklahoma City, OKBuilt 1998 · S/N 18280236 N3314VCurtiss Steve L · Fortine, MTS/N 15076458 N3314YSimas Filomeno M · Grover Beach, CABuilt 1962 · S/N 18254314 N3315EBas Part Sales LLC · Greeley, COS/N 17271501 N3315FSabbe Bros Flying Service Inc · Maddock, NDFirst renewal noticeBuilt 1966 · S/N 18257315 N3315JFlying Shiba Inus LLC · Dallas, TXS/N 15066015 N3315RTriple X Construction Inc · Camp Verde, AZBuilt 1967 · S/N 18258615 N3315TLovelady William K · Grapevine, TXBuilt 1967 · S/N 17700615 N3315VWirth Nicholas · Lake Geneva, WIBuilt 1977 · S/N R1722248 N3316JChipollini Jorge · Springdale, ARBuilt 1966 · S/N 15066016 N3316RBranstetter Jack · Ponca City, OKS/N 18258616 N3317FPeniston Mandy J · Chillicothe, MOBuilt 1966 · S/N 18257317 N3317RBanti Gustavo · Marco Island, FLBuilt 1967 · S/N 18258617 N3317TGay Don A DBA · Garfield, GABuilt 1967 · S/N 17700617 N3317USierra Aviation LLC · Fond Du Lac, WIBuilt 1963 · S/N 18254717 N33189Schrage Rodney L · Steamboat Springs, COBuilt 1975 · S/N U20602659 N3318ERodriguez Jose R · Los Angeles, CABuilt 1978 · S/N 17271502 N3318FIsland Aero LLC · Tavernier, FLBuilt 1966 · S/N 18257318 N3318RPetersen Family 1999 LLC · Anchorage, AKS/N 18502872 N3318TPipeair LLC · Vancouver, WABuilt 1967 · S/N 17700618 N3318VArledge Roone Jr · Lakewood Ranch, FLBuilt 1977 · S/N R1722249 N33195Heathco Merle S · Scappoose, ORBuilt 1976 · S/N 177RG0918 N33196One Niner Six Aviation LLC · Anchorage, AKBuilt 1975 · S/N U20602664 N3319JWelch Cooper · Lee, FLBuilt 1980 · S/N 18803627 N331CBN331cb LLC · Great Falls, MTBuilt 1979 · S/N 21063747 N331CHCh Wings LLC · Arvada, COBuilt 2022 · S/N 172S12917 N331CPCivil Air Patrol · Montgomery, ALBuilt 2019 · S/N 172S12342 N331DFDc-3 Pro Services LLC · Hailey, IDBuilt 1961 · S/N 185-0164

Back to AD 79-10-14 R1