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.

N5770EEagle Aviation LLC · Spearfish, SDBuilt 1959 · S/N 17270N5770GVoller Jim A · Strasburg, NDS/N 15071270N5770RFurge David T · Brookton, MEBuilt 1965 · S/N 17253439N57711Moss Donald C Jr · Morristown, TNBuilt 1983 · S/N 18268335N5771AHunt Jack D · Wilmington, NCBuilt 1956 · S/N 28371N5771BMorris Jerry W · Deer Trail, COBuilt 1956 · S/N 33771N5771JRegistered aircraftBuilt 1971 · S/N 21059471N5771RWilson Bach Myrl · Piedmont, SCBuilt 1965 · S/N 17253440N5772ALawlor Stephen M · Saint Joseph, MOBuilt 1956 · S/N 28372N5772GBean Dale R · Moreno Valley, CABuilt 1969 · S/N 15071272N5773AMelton James A · Mayflower, ARBuilt 1956 · S/N 28373N5773EOppegard Nicholas · Eagle River, AKS/N 17273N5773REnev Ivan E · Wood Dale, ILS/N 17253442N5774ALoughney Michael L · Indialantic, FLBuilt 1956 · S/N 28374N5774BAshiku Phillip · Ukiah, CABuilt 1956 · S/N 33774N5774GHuffman Jacob M III · Burleson, TXBuilt 1969 · S/N 15071274N5774RBallard Thomas L · Seguin, TXBuilt 1965 · S/N 17253443N5775AWeber Francis W Jr · Le Sueur, MNBuilt 1956 · S/N 28375N5775BBrindley Paul A · Plainwell, MIS/N 33775N5775EGates Rebecca S · GeorgetownNon-citizen corporation, flight hours not reportedS/N 17275N5776BTjp@Jax Inc · Zephyrhills, FLBuilt 1956 · S/N 33776N5776CBuchanan William A · Snohomish, WABuilt 1950 · S/N 19730N5776EHayden Dale G · Salome, AZBuilt 1959 · S/N 17276N5776GWilliams Timothy · Byron, GABuilt 1969 · S/N 15071276N5776RKatri Thomas L · Conroe, TXBuilt 1965 · S/N 17253445N5776TClark Jeffrey Wayne · Piedmont, MOBuilt 1964 · S/N 17251676N5777BScrews Elisha J · Owens Cross Roads, ALBuilt 1956 · S/N 33777N5777CZola Harry · Wasilla, AKS/N 19731N5777GZawtocki Ronald · Little Falls, NYBuilt 1969 · S/N 15071277N5777RSumner Gary W · Knoxville, TNBuilt 1965 · S/N 17253446N5778JTwin Falls Fliers Inc · Twin Falls, IDBuilt 1974 · S/N 18263530N5778TGreen Hornet Aviation LLC · Bloomsburg, PABuilt 1964 · S/N 17251678N5779GChapman Jeremy R · Niagara Falls, NYBuilt 1969 · S/N 15071279N5779JBeavers Air LLC · Fort Walton Beach, FLBuilt 1971 · S/N 21059479N5779TArdmore Aviation LLC9667 · Novelty, OHBuilt 1964 · S/N 17251679N577AUBeck Patrick · Algonquin, ILBuilt 2015 · S/N 18282370N577CDSeger Properties Ltd · Fort Loramie, OHBuilt 1969 · S/N P20600609N577CTShaw Air Limited LLC · Mansfield, PAS/N 18266546N577EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13091N577FAN577fa LLC · Redondo Beach, CABuilt 2004 · S/N 172S9577N577FGRidgeline Assets LLC · Wilmington, DEBuilt 2023 · S/N 172S13079N577NDAir Shares LLC · Casper, WYBuilt 2010 · S/N 172S10986N577SPTexas State Technical College · Waco, TXBuilt 2000 · S/N 172S8503N577TCCrimson Aviation LLC · Helena, MTBuilt 1980 · S/N 18267564N577TZWestbank Fishing LLC · Kiln, MSBuilt 2002 · S/N 18281123N5780GAlvarez Faust M · Helena, MTBuilt 1969 · S/N 15071280N5781BRobinson Stephen L · Celina, TXBuilt 1956 · S/N 33781N5781CSipple Ronald W Jr · Gardner, KSBuilt 1950 · S/N 19735N5781ECopithorne Richard J · West Paris, MES/N 17281N5781GWilliams Lynwood A · Clayton, NCBuilt 1969 · S/N 15071281
Back to AD 79-10-14 R1