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.

N7154XCapra James · Yakutat, AKBuilt 1961 · S/N 15059254N71551Aivcon Inc · Charlevoix, MIBuilt 1969 · S/N 18259662N7155ABrown Benjamin K · Norman, OKBuilt 1956 · S/N 29255N7155ETriple F Flying Club Inc · Indianapolis, INBuilt 1959 · S/N 52155N7155FJr Imaging Logistics Inc · Pasco, WABuilt 1966 · S/N 15063755N7155MEverhart Leon J · Gould City, MIBuilt 1958 · S/N 55455N7155NQualitair LLC Trustee · MichelstadtBuilt 1999 · S/N 18280554N7155QValley Ltd Of Fayetteville · Fayetteville, NCBuilt 1972 · S/N 17260455N7155TSw Idaho Flying Cooperative LLC · Boise, IDBuilt 1960 · S/N 46755N71560Kansas State University Parachute Club · Manhattan, KSBuilt 1969 · S/N 18259663N71569Ziegler Andrew J · Clyde, OHBuilt 1969 · S/N 18259667N7156ELittle Bird Airways LLC · Hamburg, NYBuilt 1959 · S/N 52156N7156MKeddie Mark V · North Huntingdon, PABuilt 1958 · S/N 55456N7156QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260456N71573Steed David A · Oklahoma City, OKBuilt 1969 · S/N 18259668N7157BOwyhee Aviation LLC · Provo, UTBuilt 1999 · S/N 18280555N7157ECowell Norman B III · Lomita, CAS/N 52157N7157GAero Quest LLC · Olive Branch, MSBuilt 1969 · S/N 17258857N7157XCorriveau Florian J · White Field, NHFirst renewal noticeBuilt 1961 · S/N 15059257N71582Papon Bruce G · Hardtner, KSBuilt 1969 · S/N 18259671N71583Zidek Lawrence Paul · Onaga, KSBuilt 1969 · S/N 18259672N71584Burris Joshua William · Maiden, NCBuilt 1969 · S/N 18259673N71587Bynum Jerry R · San Angelo, TXBuilt 1969 · S/N 18259674N71589Carr Mark F · Anchorage, AKBuilt 1969 · S/N 18259676N7158EHall Craig A · Corvallis, MTBuilt 1959 · S/N 52158N7158GHawk Aviation Inc · Rush City, MNBuilt 1969 · S/N 17258858N71595Registration Pending · Nampa, IDRegistration pendingBuilt 1969 · S/N 18259679N71598Watkins William G IV · Aptos, CABuilt 1969 · S/N 18259681N7159AWilgar Aero LLC · Palestine, ARBuilt 1956 · S/N 29259N7159FBrooks James · West Liberty, OHBuilt 1966 · S/N 15063759N7159GN7159g LLC · Jacksonville, ARS/N 17258859N7159SSaathoff Michael A · Stockton, MOS/N 15067859N715BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280941N715CN9lu Aviation LLC · Wilmington, DEFirst renewal noticeBuilt 1978 · S/N 18052947N715CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281712N715DFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2005 · S/N 18281734N715GHodge Cle'Jae J · St Thomas, VIBuilt 1980 · S/N 172RG0653N715GTTuttle Air Lc · Nashville, TNBuilt 1967 · S/N 18258159N715HPOhio Department Of Public Safety · Columbus, OHBuilt 2000 · S/N 18280921N715LULiberty University Inc · Lynchburg, VABuilt 2016 · S/N 172S11722N715MASim International Inc · Fort Mill, SCBuilt 1980 · S/N 18267469N715MTSaz Dynamics LLC · Daly City, CABuilt 2008 · S/N 172S10873N715RCEide David B · Saint Michael, MNBuilt 2002 · S/N 18281085N715SHPotoczek Jeffrey · Century, FLS/N 15070696N715WBRichardson Clay W · Ozona, TXBuilt 1978 · S/N 18052915N715WMBgi Aircraft Management LLC · Alpharetta, GABuilt 2020 · S/N 172S12536N71607Hamby Robert Eidson · Martin, GABuilt 1969 · S/N 18259685N7160AStainaker Le Roy R · Cleveland, TXBuilt 1956 · S/N 29260N7160EKenyon Larry H · Grafton, OHBuilt 1959 · S/N 51717N7160FFoxy Bankins LLC · Hobe Sound, FLBuilt 1966 · S/N 15063760
Back to AD 79-10-14 R1