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.

N94303Nelson Ryan L · League City, TXBuilt 1978 · S/N 18266404N94304Hamilton Francis D III · Olney, TXBuilt 1978 · S/N 18266405N9430AWalker Neiman J · Denton, TXBuilt 1949 · S/N 15251N9430BFuture Flyers Of Connecticut LLC · Simsbury, CTBuilt 1958 · S/N 55230N9430CRoberts Creek Holdings LLC · Bakersfield, CABuilt 1955 · S/N 31828N9430MKruschwitz David A · Anchorage, AKBuilt 1974 · S/N 15075669N9430TRmb Leasing Inc · Dover, DEBuilt 1960 · S/N 57230N9431ADelta Ridge Farms LLC · Oak Grove, LABuilt 1949 · S/N 15252N9431MMeridian Airport Authority · Meridian, MSBuilt 1976 · S/N 18264752N9431XShives Investments LLC · Zavalla, TXBuilt 1985 · S/N 18268523N94328Gottschalk John R · Atwater, CABuilt 1978 · S/N 18266410N9432CTexas Co Title Inc · Kalispell, MTS/N 31830N9432DRegistered aircraftBuilt 1984 · S/N 172RG1160N9432MRound Table Aviation LLC · Munster, INFirst renewal noticeBuilt 1970 · S/N 21059332N94334Play For Today LLC · Michigan City, INBuilt 1978 · S/N 18266412N94338Auto Action LLC · Peralta, NMBuilt 1978 · S/N 18266415N9433ABohl Howard M · Temecula, CABuilt 1949 · S/N 15254N9433EKozma Peter · San Diego, CABuilt 1979 · S/N 17272264N9433LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276556N9433MDels Inc · Mountain Home, ARBuilt 1970 · S/N 21059333N9433RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 20608337N9433TDoyle Victoria L · Salem, ORBuilt 1960 · S/N 57233N9433XVorlander Daniel S · Mount Pleasant, SCBuilt 1985 · S/N 18268525N9434594345 LLC · Ashaway, RIBuilt 1978 · S/N 18266417N9434BNamtvedt Erik · Wasilla, AKS/N 55234N9434NAnderson Thomas R · Renton, WABuilt 1981 · S/N 18504355N9434TChurch Philip M · Statesville, NCBuilt 1960 · S/N 57234N94359Jbm Enterprises LLC · Bristol, RIS/N 18266419N9435ARoberts Ralph Russell · Seaman, OHBuilt 1949 · S/N 15256N9435BPalladino Michael A · Pinehurst, NCFirst renewal noticeBuilt 1981 · S/N 172RG0821N9435CBackcountry Adventures LLC · Big Lake, AKBuilt 1955 · S/N 31833N9435MEngelhardt Angelo Lomeli · Spring, TXBuilt 1976 · S/N 18264754N9435ZChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280273N9436APyeatt David W · Palm Beach Gardens, FLBuilt 1950 · S/N 15462N9436BWhitsell Jesse T · Sterling, CTBuilt 1958 · S/N 55236N9436MIkg Air LLC · Page, AZBuilt 1981 · S/N 20700689N94371Coppage Farm Services Inc · Braggadocio, MOBuilt 1978 · S/N 18266421N9437DRichmor Aviation Inc · Scotia, NYBuilt 1984 · S/N 172RG1161N9437UAom Aircraft LLC · Wilmington, DES/N 15078385N9438ACorder Charles W · Fairfield, OHBuilt 1949 · S/N 15259N9438CKrupinski Floyd M · Chugiak, AKBuilt 1955 · S/N 31836N9438HBering Capital LLC · Anchorage, AKS/N 17266155N9438MIdaho Transportation Department · Boise, IDBuilt 1978 · S/N U20604546N9438NSallmon James Henry · Sandpoint, IDBuilt 1981 · S/N 18504356N9438TBray Max W Jr · Dora, ALBuilt 1960 · S/N 57238N94391Gall Michael R · Breckenridge, COBuilt 1978 · S/N 18266423N9439AFullerton Paul S · Saint Ignace, MIBuilt 1949 · S/N 15260N9439BAv Dak Inc · Crystal, NDBuilt 1981 · S/N 172RG0822N9439CYellowstone Overflight Inc · Belgrade, MTBuilt 1955 · S/N 31837N9439ESilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1979 · S/N 17272265
Back to AD 79-10-14 R1