AD 79-10-14 R1

Registered aircraft · 56,582

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
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.

N6797EJoe Bob Nelson · Chickasha, OKBuilt 1978 · S/N 17272069N6797FGriswold M Dallas · Cordele, GABuilt 1966 · S/N 15063397N6797MAim East Bay Aviation LLC · Danville, CABuilt 1975 · S/N 18263841N6797RJts Management Inc · Lincoln, NEBuilt 1966 · S/N T210-0197N6798GCowan Ronnie C · Glasgow, KYS/N 15072298N6798HWnk Leasing LLC · Lewes, DEBuilt 1975 · S/N 17265586N6799GWetzler Brian · Bainbridge Island, WABuilt 1970 · S/N 15072299N6799MCoop Aero LLC · New Albany, MSBuilt 1975 · S/N 18263843N6799SAdr Aircraft Service Inc · Burbank, CABuilt 1967 · S/N 15067599N679CPCivil Air Patrol · Maxwell Afb, ALBuilt 2010 · S/N 18282248N679DCM & G Aircraft Management LLC · Englewood, COBuilt 2016 · S/N 172S11679N679DLBlink Squirrel Aviation LLC · Cherokee, IABuilt 1970 · S/N 17259138N679DWSunrise Aviation Inc · Ormond Beach, FLBuilt 2000 · S/N 17280940N679EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12754N679JTAdventure Aviation Sales Inc · Jeffersonville, INBuilt 1976 · S/N 17702428N679MCVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 18281678N679RMMattox Richard A · Friday Harbor, WABuilt 1977 · S/N 18052820N679UPRegistration Pending · Maxwell, CARegistration pendingBuilt 1978 · S/N 18266598N67ABScaglia Bennett P · Port Orange, FLBuilt 1975 · S/N A1500599N67ADCjr Wings · Harrisburg, PABuilt 1976 · S/N 18265029N67BJMccorkle Joseph Press II · Tyronza, ARBuilt 1961 · S/N 18050923N67BL206 LLC · Keizer, ORBuilt 1967 · S/N P206-0397N67BRDeep South Sky Llp · Wetumpka, ALBuilt 1973 · S/N 18261611N67CHPrestige Aviation LLC · Lake Havasu City, AZBuilt 1981 · S/N 21064354N67CNPrichard Brian E · Caledonia, MIBuilt 1968 · S/N 17257566N67DGD&B Aircraft Leasing LLC · Anchorage, AKBuilt 1974 · S/N U20602375N67DJSunrise Aero LLC · Nikiski, AKBuilt 1974 · S/N U20602326N67DSHangar 39 LLC · Culpeper, VAS/N A185E1284N67DVArizona Airplay LLC · Somerton, AZS/N 50359N67FPeterson Mark J · Flagstaff, AZBuilt 1953 · S/N 30343N67GRQuinlan Sherman L · Georgetown, TXBuilt 1966 · S/N 15064854N67JAJaars Inc · Waxhaw, NCBuilt 1980 · S/N U20605781N67JMEck Gary A · Osceola, INBuilt 1973 · S/N 17701940N67KEGran Tulley Corp · Arcadia, FLBuilt 1967 · S/N 18257834N67MMSingh Ravinder · Happy Valley, ORBuilt 1975 · S/N 17702269N67MRGrandview Services LLC · Walnut Creek, CABuilt 1999 · S/N 18280505N67MSAmerican Aviation Inc · Brooksville, FLBuilt 2001 · S/N 172S8993N67RAKirkwood Billie R · El Paso, TXS/N R172-0090N67RVHopman Richard G · Oxford, MIBuilt 1966 · S/N 17255157N67SSchultz Daniel A · Tipp City, OHBuilt 1974 · S/N P3370168N67WJBusiness As Usual LLC · Spartanburg, SCBuilt 1973 · S/N 15074915N67WTHenderson Ronald W · Marietta, OHBuilt 1968 · S/N 18259488N67WWFrontier Fence LLC · Fallon, NVBuilt 1966 · S/N 18051812N6800APilots You Can Trust LLC · Fayetteville, NCBuilt 1956 · S/N 28900N6800ENo Limits Aviation Inc · Hayden, IDFirst renewal noticeS/N 56300N6800HBlack Industries LLC · Helena, MTS/N 17265587N6800MTerhune Anthony L · Arlington, TNBuilt 1975 · S/N 18263844N6800XNew Vision Aviation Inc · Fresno, CABuilt 1960 · S/N 47700N6801GDelta Ridge Farms LLC · Oak Grove, LAS/N 15072301N6802AAeromasters Inc · Surgoinsville, TNBuilt 1956 · S/N 28902
Back to AD 79-10-14 R1