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.

N9948ZAlien Invaders LLC · Medina, WABuilt 1983 · S/N U20606767N9949NFox Heather J · Bettles Field, AKBuilt 1975 · S/N 18052604N994CDNavair LLC · Mount Vernon, OHBuilt 1979 · S/N 21063312N994JPHinen Paul H · Soap Lake, WABuilt 1973 · S/N 15074483N994LAJaguar Aviation LLC · Hillsboro, ORBuilt 2024 · S/N 172S13120N994NACurry Lloyd F · Karnack, TXBuilt 1966 · S/N 17254820N994NZFrakes Stephen A · Frisco, COBuilt 1978 · S/N 21062470N994RJAirline Pilot Careers LLC · Champlin, MNBuilt 1977 · S/N 18503260N994WWMabry Properties And Holdings LLC · Jonesboro, ARBuilt 1999 · S/N 17280719N99501Bennett Gary R · Anchorage, AKBuilt 1971 · S/N 18260598N99508Lee Randall Ross · Houston, TXBuilt 1985 · S/N 17276456N9950AHilbert Lee D · Hampton, NJBuilt 1950 · S/N 19310N9950NRegistration Pending · Petersburg, AKRegistration pending, pending cancellationS/N 18052605N9950XHedlund Mark · Kasilof, AKBuilt 1961 · S/N 185-0150N99517Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276459N9951EBlue Skylane LLC · Sunriver, ORBuilt 1975 · S/N 18264011N9951HFormula 182 LLC · Phoenix, AZBuilt 1981 · S/N 18268137N9951NAckerman Dennis W · Anchorage, AKBuilt 1975 · S/N 18052606N9951V9951v Aircraft Leasing LLC · Spanish Fork, UTS/N 17264569N9951XBrown Rosalee Jo · Minnetrista, MNBuilt 1961 · S/N 185-0151N99527Delta State University · Cleveland, MSBuilt 1985 · S/N 17276460N9952MAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1976 · S/N 207-00345N9952RBlanchard Ken E · Lumberton, MSS/N U20606997N9952ZMcdougall Enterprises LLC · Tualatin, ORBuilt 1983 · S/N U20606771N99532Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276462N9953ESutton Gregg S · Orono, MNBuilt 1975 · S/N 18264013N9953HRegistered aircraftBuilt 1981 · S/N 18268139N9953MAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1980 · S/N 20700656N9954ANolen Donald F · Plano, TXBuilt 1950 · S/N 19314N9954BWest James R · Xenia, OHS/N 34354N9954EChase Ronald L · Payson, AZBuilt 1975 · S/N 18264014N9954HApplied Dimension LLC · Hinsdale, NYBuilt 1981 · S/N 18268140N9954NWhitmer Lyle E · Fairbanks, AKBuilt 1975 · S/N 18052609N9954TWoodford Douglas P · Colbert, WABuilt 1960 · S/N 18253054N99553Jka LLC · Notasulga, ALBuilt 1985 · S/N 17276465N9955ANelson Harry J · West Bend, WIBuilt 1950 · S/N 19315N9955ESanchez Angel David · Houston, TXBuilt 1975 · S/N 18264015N9955TWheeler Aaron T · Columbia, TNBuilt 1960 · S/N 18253055N9955XMurphy Niccolai A · Poway, CABuilt 1961 · S/N 185-0155N9956EBankuti Steve A · Littlerock, WABuilt 1975 · S/N 18264016N9956HOldtown Aviation LLC · Priest River, IDBuilt 1981 · S/N 18268141N9956MRyan Air Inc · Anchorage, AKBuilt 1983 · S/N 20700763N9956VFetch N Wag LLC · Sarasota, FLS/N R1722357N9957ADunn Ward A · Columbia, SCBuilt 1950 · S/N 19317N9957BToby Aviation LLC · Manassas, VABuilt 1957 · S/N 34357N9957EReisman Richard H · Montrose, COBuilt 1979 · S/N 17272298N9957MArctic Aviation Leasing LLC · Anchorage, AKBuilt 1983 · S/N 20700764N9957NGasper Air Spray Inc · Crookston, MNFirst renewal noticeBuilt 1975 · S/N 18052612N9957RScg Leasing LLC · Owensboro, KYBuilt 1986 · S/N U20606999N9957TDaniels Luke D · Palmer, AKBuilt 1960 · S/N 18253057
Back to AD 79-10-14 R1