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.

N7180GPearman Properties LLC · Branson, MOBuilt 1970 · S/N 17258880N71811Weed Eater LLC · Canton, OHBuilt 1969 · S/N 18259765N71812Flight Patterns LLC · Okanogan, WABuilt 1969 · S/N 18259766N71815Whipple Daniel C · Coon Rapids, MNBuilt 1969 · S/N 18259767N71818Price Norman S · Prineville, ORFirst renewal noticeBuilt 1969 · S/N 18259769N7181AWarmkessel James R · Felton, CABuilt 1956 · S/N 29281N7181FCarter Mark A · Carpinteria, CABuilt 1966 · S/N 15063781N7181MArmstrong Bruce · Port Orchard, WABuilt 1958 · S/N 55481N7181TSwanson G N · Meridian, IDBuilt 1959 · S/N 46781N7181XMozina Robert J · Mc Alpin, FLBuilt 1961 · S/N 15059281N71821Hayes Harlan L · Salem, ORS/N 18259770N7182AEdm Flying Inc · Nevada, MOBuilt 1956 · S/N 29282N7182EShoreline Consulting Inc · Bryan, TXBuilt 1959 · S/N 52182N7182GBar-Od-4 Cattle Co LLC · Laredo, TXBuilt 1969 · S/N 17258882N7182MThayer Stephen Claude · High Point, NCBuilt 1958 · S/N 55482N7182QMullins Albert A · Boling, TXS/N 18267345N7182SHoward William M · Greensburg, PABuilt 1967 · S/N 15067882N7182TTdp LLC · Caldwell, IDBuilt 1959 · S/N 46782N71831Kellogg Morgan · Missoula, MTBuilt 1969 · S/N 18259771N71833Vega Al · Windsor, CAS/N 18259772N7183AElk & Ram Aviation Group LLC · San Antonio, TXBuilt 1956 · S/N 29283N7183FN7183f LLC · Spanish Fork, UTBuilt 1966 · S/N 15063783N7183MSnavely Deborah B · Lake Placid, FLBuilt 1958 · S/N 55483N7183QFlying Wild LLC · Yarmouth, MEBuilt 1972 · S/N 17260483N71844Rusinsky Michael John · Amagansett, NYBuilt 1969 · S/N 18259775N71846C3 Aviation LLC · Eustis, FLBuilt 1969 · S/N 18259776N7184AGarrison Randy L · Queen City, TXBuilt 1956 · S/N 29284N7184FYoke Aviation LLC · Bowling Green, KYBuilt 1966 · S/N 15063784N7184QHolubar Properties Inc · Mckinney, TXBuilt 1973 · S/N 18262045N7184SCade Steven V · Lopez, WABuilt 1967 · S/N 15067884N7184THelderman Laban W · Newton, NCS/N 46784N7185ENenadic John P · Camas, WABuilt 1959 · S/N 52185N7185GJones Mark R · Denton, MDS/N 17258885N71860Young Reginald L · Fort Worth, TXBuilt 1969 · S/N 18259783N71866Lkn Skylane LLC · Mooresville, NCBuilt 1969 · S/N 18259785N71867Friend Troy L · Wyandotte, OKBuilt 1969 · S/N 18259786N7186AValiair Lc Trustee · Casper, WYBuilt 1956 · S/N 29286N7186CRegistered aircraftBuilt 1973 · S/N 680N7186SEagle Equity Inc · Valparaiso, INBuilt 1967 · S/N 15067886N7186XSmith Calvin E · North Augusta, SCS/N 15059286N71876Rasmussen Paul · Long Lake, NYBuilt 1969 · S/N 18259788N71879Sale Reported · Greeley, COSale reported, pending cancellationBuilt 1969 · S/N 18259789N7187AHannah David W · Richmond, TXBuilt 1956 · S/N 29287N7187FHoranzy Paul S · N Grosvenordl, CTBuilt 1966 · S/N 15063787N7187QChestnut Ridge Flying Club · Latrobe, PABuilt 1972 · S/N 17260487N7187RFlying Roaches LLC · Dallas, TXBuilt 1999 · S/N 18280557N71880Meeks Michael D · Marion, TXBuilt 1969 · S/N 18259790N71884Smith John L Trustee · Zephyr Cove, NVBuilt 1969 · S/N 18259792N7188EWashick Timothy J · South Lake Tahoe, CABuilt 1959 · S/N 52188N7188FCopeland Lance Andrew · Jacksonville, ARBuilt 1966 · S/N 15063788
Back to AD 79-10-14 R1