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.

N2634UCoolaire LLC · Boerne, TXBuilt 1963 · S/N 17250234 N2634VClanton Leslie G · Yazoo City, MSFirst renewal noticeBuilt 1948 · S/N 18144 N2635BGrimes Jeremy M · Wasilla, AKBuilt 1959 · S/N 50390 N2635GStockton Finance Inc · New Braunfels, TXBuilt 1959 · S/N 51935 N2635JWakefield Diep Thao T · Kelseyville, CABuilt 1966 · S/N 15065635 N2635KVerdi Stephen · Newtown, PABuilt 1978 · S/N 18053020 N2635LQueen Matthew E · Shenandoah, VAS/N 17255835 N2635RJong Hoon Cho · Rch Palos Vrd, CABuilt 1967 · S/N 18258335 N2635VLaycock Justin D · Johnson City, TNS/N 18145 N2636FCernilia James J · Newport Beach, CABuilt 1965 · S/N 18256736 N2636GHousken George E · Gardnerville, NVFirst renewal noticeBuilt 1959 · S/N 51936 N2636JScott William B · Owensville, INBuilt 1966 · S/N 15065636 N2636VMclaughlin Nathaniel D · Clayton, CABuilt 1958 · S/N 18146 N26379Wings Over Texas Holdings LLC · Denton, TXBuilt 1998 · S/N 17280573 N2637FMccrum James M · Seattle, WABuilt 1965 · S/N 18256737 N2637GSalisbury Jonathan T · Seabeck, WABuilt 1959 · S/N 51937 N2637LAustin Timothy · Abbeville, SCBuilt 1967 · S/N 17255837 N2637UMarks Charles A III · Apalachicola, FLBuilt 1963 · S/N 17250237 N2638DWallace Donald F · Palmer, AKBuilt 1952 · S/N 20790 N2638GEvans Steven H · Hattiesburg, MSBuilt 1959 · S/N 51938 N2638LMorgan Todd W · Roscoe, ILBuilt 1967 · S/N 17255838 N2638VWells Larry C · Flowood, MSBuilt 1974 · S/N 177RG0638 N2638ZHowlett Corey W · Wasilla, AKBuilt 1963 · S/N 185-0638 N2639DHanson Scott · Anchorage, AKBuilt 1952 · S/N 20791 N2639FHendershott Kevin J · Vacaville, CABuilt 1965 · S/N 18256739 N2639GHusted Dean T · Hicksville, OHBuilt 1959 · S/N 51934 N2639VBowen Keith S · Lyle, WABuilt 1974 · S/N 177RG0639 N263DWWarren David T · Mobile, ALBuilt 1959 · S/N 51970 N263EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13503 N263LPMarkman William J · The Dalles, ORS/N 18265959 N263SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13406 N2640USealey Gary W · Saint Pauls, NCBuilt 1963 · S/N 17250240 N2640VBube Douglas G · Clarkston, WABuilt 1974 · S/N 177RG0640 N2640YMarc Aircraft Holding LLC · Soldotna, AKBuilt 1962 · S/N 18051140 N2641LTm Aviation Services LLC · Riverside, CABuilt 1967 · S/N 17255841 N2641RHowatt Scott · Hannah, NDBuilt 1967 · S/N 18258341 N2642GWillis Andrew B · Wasilla, AKBuilt 1959 · S/N 51942 N2642LRiggin Flight Service Inc · Madison, SDS/N 17255842 N2642QLongerbone Danny L · Fishers, INBuilt 1970 · S/N 17258931 N2642SReich Stephen Barry · Kentfield, CABuilt 1976 · S/N 21061345 N2643FWortham Bethany S · Soldotna, AKBuilt 1965 · S/N 18256743 N2643GBorland Gregg A · Elkhart Lake, WIBuilt 1959 · S/N 51943 N2643KWashington Walt W · Collierville, TNBuilt 1978 · S/N 18053023 N2643QOst Jesse E · Hunter, KSBuilt 1966 · S/N 18257843 N2643RNorthern Wings LLC · Spokane, WABuilt 1967 · S/N 18258343 N2643UGaring Gerald R · Schenectady, NYBuilt 1963 · S/N 17250243 N2643VGorman Sean P · Superior, COBuilt 1974 · S/N 177RG0641 N2644RColler Randy L · Jackson, MIBuilt 1967 · S/N 18258344 N2645FMichel John Vernon III · Westminster, MDBuilt 1965 · S/N 18256745 N2645GMurdoch Kyle · Burns, WYBuilt 1959 · S/N 51945

Back to AD 79-10-14 R1