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.

N9401HConstantine Costas T · Newington, CTS/N 17266143N9402CMontgomery Robert L · Port Angeles, WABuilt 1955 · S/N 31800N9402DH C E Leasing LLC · Cleveland, TNBuilt 2012 · S/N 18282312N9402UMayrant Dawson Z · College Station, TXS/N 15078350N9402XSewell John · Sugar Grove, ILBuilt 1961 · S/N 21057702N94035Husbands David · Bosque, NMBuilt 1974 · S/N 21060487N9403AJ & K Flying LLC · Marengo, OHS/N 15224N9403CDobson Michael W · Konawa, OKBuilt 1955 · S/N 31801N9403UPaschal Engineering Inc · Houston, TXFirst renewal noticeBuilt 1976 · S/N 15078351N9403YFlorida Emergency Management Associations Inc · West Palm Beach, FLBuilt 1981 · S/N 21064498N9404AMorrison Mark C · Marfa, TXBuilt 1949 · S/N 15225N9404BRutledge Dianna G · Winder, GABuilt 1958 · S/N 55204N9404CBergh Gene H · Roberts, WIFirst renewal noticeBuilt 1955 · S/N 31802N9404FBas Part Sales LLC · Greeley, COBuilt 1997 · S/N 17280229N9404HSowell Richard G · San Jose, CABuilt 1975 · S/N 17266145N9404UWhitcomb James F · West Ossipee, NHBuilt 1976 · S/N 15078352N94059Moriarty Gerald J · Anchorage, AKS/N 18503275N9405ACronin John W Jr · Denver, COBuilt 1949 · S/N 15226N9405CRamsower Charles M · Parma, IDBuilt 1955 · S/N 31803N9405RJones Lance E · Duncan, OKS/N U20606853N9405UBishop Michael E · Clarkston, WAS/N 15078353N94061Guinn LLC · Bothell, WABuilt 1977 · S/N 18503276N9406AStowell Colt M · Homedale, IDBuilt 1949 · S/N 15227N9406UMontgomery Paul Richard · Fredericksburg, VABuilt 1976 · S/N 15078354N94077Milky Way LLC · Fresno, CABuilt 1974 · S/N 21060497N9407CTyrrell Richard E · Central, AKBuilt 1955 · S/N 31805N9407HB2w Corporation · Winona, MNBuilt 1975 · S/N 17266147N9407TBodin Logan T · Lake Charles, LAS/N 57207N9407XDriggers Kenneth Jerry · Rialto, CABuilt 1961 · S/N 21057707N9408ADill Steven S · Hesperia, CAS/N 15229N9408HWanamaker Jeffrey Cass · Fall City, WABuilt 1981 · S/N 18267943N9408LMccallum David DBA · Napa, CABuilt 1986 · S/N 17276551N9408UTenhoff Lee L · Homer, AKBuilt 1976 · S/N 15078356N9409LLaguna Verde Leasing Inc · Wilmington, DEBuilt 1986 · S/N 17276552N9409TBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 57209N9409UFree Wade · Sharon, OKBuilt 1976 · S/N 15078357N9409XEnergy Transfer Aviation LLC · Spring, TXBuilt 1985 · S/N 18268515N940AMOracle Aviation LLC · Omaha, NEBuilt 1981 · S/N 17275286N940CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282405N940FSYogini Modi · Homestead, FLBuilt 1979 · S/N 17272350N940HPKansas Highway Patrol · Topeka, KSS/N 20608343N940MAMoore Charles H · Richmond, TXBuilt 1998 · S/N 18280360N940RMSchool Of Missionary Aviation Technology · Ionia, MIBuilt 2003 · S/N 172S9386N940WSkyhawks Inc · Westminster, COBuilt 1965 · S/N 18256606N9410AAllen Dennis R · San Mateo, CABuilt 1949 · S/N 15231N9410MWomack David H · Rayville, LAS/N 21059310N9410XHendrix Philip R · Corpus Christi, TXS/N 21057710N9411ARenkenberger James H · Saint Joe, INBuilt 1949 · S/N 15232N9411HFeaga Charles C · Abbot, MES/N 18503437N9411LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276553
Back to AD 79-10-14 R1