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.

N978CLa Avioneta LLC · Raymondville, TXBuilt 1979 · S/N 18267017N978CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280209N978FASky Training LLC · West Milford, NJBuilt 2002 · S/N 172S9078N978KWOrtega Aviation Services LLC · Wichita, KSBuilt 2011 · S/N 18282278N978RABdk Pegasus LLC · Bastrop, TXBuilt 1998 · S/N 18280213N978SAMarine Tech One LLC · Dover, DEBuilt 2002 · S/N 172S9178N978SPLlp Leasing Group LLC · Lewes, DEBuilt 1999 · S/N 172S8181N97902Hanson Mike D · Vinton, IABuilt 1979 · S/N 18267242N97903Aerial Imaging Inc · South Bend, INBuilt 1979 · S/N 18267243N9790BGreen William D · Fairbanks, AKBuilt 1957 · S/N 50088N9790GIsaac Gerald B · Spencerport, NYBuilt 1979 · S/N 17273636N9790XPhenix LLC · Dayton, WABuilt 1962 · S/N 21058090N97911Mosley Thomas W · Federal Way, WABuilt 1979 · S/N 18267244N97912Banda Gilbert · Hudson Oaks, TXBuilt 1979 · S/N 18267245N97919Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 17276239N9791BHicks Keith · Sweetwater, TNS/N 172RG1039N9791FRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1997 · S/N 17280062N9791GAndreshak Thomas G · Bowling Green, OHBuilt 1977 · S/N U20603830N9791HNoga Timothy · Corvallis, MTBuilt 1981 · S/N 18268027N9791VBarazani Jacob J DBA · Chanute, KSBuilt 1966 · S/N 188-0241N97921Flywell Aviation LLC · Bowling Green, KYS/N 17276240N97924Kenney Industries Inc · Dallas, TXBuilt 1979 · S/N 18267247N97927N97927 LLC · North Royalton, OHBuilt 1979 · S/N 18267248N9792VHavu Aviation LLC · Irvine, CABuilt 1974 · S/N 17264504N9793ACoulter Robert · South Bend, INBuilt 1950 · S/N 19254N9793HYarmo Robert P · Pelham, NHBuilt 1981 · S/N 18268028N9793XMiller Andy D · Marana, AZS/N 21058093N97945Kent State University · Stow, OHBuilt 1984 · S/N 17276241N97947Civil Air Patrol · Maxwell Afb, ALBuilt 1984 · S/N 17276242N9794ABurlace Thomas J III · Aurora, COBuilt 1950 · S/N 19255N9794GCherry James J · Woodside, CABuilt 1972 · S/N 18052294N9794MYr-Aircraft Leasing LLC · Bethel, AKBuilt 1981 · S/N 20700730N9794VCooke George C IV Trustee · Richland, WABuilt 1974 · S/N 17264505N9794XLeingang Mark J · Olympia, WABuilt 1962 · S/N 21058094N97956N97956 LLC · Mesa, AZBuilt 1979 · S/N 18267253N97957Jca Aviation LLC · Wentzville, MOS/N 182-67254N97958Plate Jack R · Clarklake, MIBuilt 1979 · S/N 18267255N9795APatterson Roland O · Semmes, ALS/N 19256N9795BSilver Express Co DBA · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1982 · S/N 172RG1042N9795TWhite Cap Aviation LLC · Amsterdam, NYS/N 47595N9795VWilliams Bob L · Udall, KSS/N A1500565N97961Rutter Matthew J · Great Falls, MTBuilt 1979 · S/N 18267256N97963Nichols Timothy · Poulsbo, WAS/N 18267257N97968Moses Fredric P · Wayland, MABuilt 1979 · S/N 18267258N9796VKelley Aircraft LLC · Weyers Cave, VAS/N 17264506N9796XHulett George A · Woodland Hills, CABuilt 1962 · S/N 21058096N97970Mcveigh Scott M · Westlake Village, CABuilt 1979 · S/N 18267259N97971Gregory Scott L · Prescott, AZBuilt 1979 · S/N 18267260N97975Winga Aero Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 18267262N9797GPowers Burton L · Anchorage, AKS/N 18052297
Back to AD 79-10-14 R1