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.

N988PWChristiansen Bruce L · Windham, MEBuilt 1978 · S/N R1722948N988RAFifteen-Sixty LLC · Ottawa Hills, OHBuilt 1997 · S/N 18280022N988TCSpaulding Bernard B · Terrell, TXBuilt 1998 · S/N 18280297N988WUBravo Whiskey Aviation LLC · Louisville, KYBuilt 1998 · S/N 17280567N9890ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 18268465N9890HDe Rico Nicolas · Tracy, CABuilt 1981 · S/N 18268094N9890JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1976 · S/N A1500699N9890MR & R Brown Inc · Sun Valley, IDBuilt 1977 · S/N 21062085N9890XSelman Jett · Anchorage, AKBuilt 1961 · S/N 1850090N9890YValiair Lc Trustee · Casper, WYS/N 21064630N98913Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276378N9891GOuellette Kevin E · Frederick, OKBuilt 1971 · S/N 17259791N9891TDunkley Bret Y · Kotzebue, AKS/N 47691N98923Costa Flying Service Inc · Painted Post, NYBuilt 1985 · S/N 17276381N9892GFritz John P · Belvidere, NJBuilt 1971 · S/N 17259792N9892MBogner Aviation LLC · Dover, DEBuilt 1976 · S/N 18264789N9892QLytle Jack J · Omaha, NEBuilt 1975 · S/N 17265836N9893HBain Aviation Inc · Weiser, IDBuilt 1981 · S/N 18268095N9893QDougherty Casey · Rock Island, WABuilt 1975 · S/N 17265837N9894EDebski Matthew B · Belmont, CABuilt 1975 · S/N 18263955N9894G1s6 Flying Club Inc · Sandpoint, IDS/N 17259794N9894JKosko Stanley G · Seattle, WABuilt 1976 · S/N A1500703N9894QKarpov Konstantin A Trustee · Fort Bragg, CABuilt 1975 · S/N 17265838N9894YRaymond Andy · Council Bluffs, IABuilt 1981 · S/N 21064632N98954Emerson Solutions LLC · Bellingham, WABuilt 1985 · S/N 17276384N9895ETurnkey Aviation LLC · North Las Vegas, NVBuilt 1985 · S/N 18268467N9895FRetro Modern Aviation LLC · Manitou Springs, COBuilt 1997 · S/N 17280179N9895GKellerman Roger B · Rockford, ILBuilt 1971 · S/N 17259795N9895QCk Leasing Services LLC · Wilmington, DEBuilt 1975 · S/N 17265839N9895VTogo Aviation Services LLC · Palmer, AKBuilt 1974 · S/N 17264550N98960Buiqui Aerospace Corp · Kissimmee, FLBuilt 1985 · S/N 17276387N9896HHilltop Aviation LLC · Rowlesburg, WVBuilt 1981 · S/N 18268097N9896JVande Berg David M · Sioux Center, IABuilt 1976 · S/N A1500705N9896XKing Kevin J · Angle Inlet, MNBuilt 1961 · S/N 1850096N9897FPinnacle Aviation Services Inc · Encinitas, CAS/N 17280180N9897MAcme Aviation USA LLC · Nashville, TNBuilt 1976 · S/N 18264794N9897QAbove All Aviation Inc · Santa Barbara, CABuilt 1975 · S/N 17265841N98981Airplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1985 · S/N 17276390N98987Civil Air Patrol Inc · Maxwell Afb, ALS/N 17276391N9898ELamar Rosa E · Santa Paula, CAS/N 18263958N9898QSecond Wind Aviation Corp · Friday Harbor, WABuilt 1975 · S/N 17265842N9898THumphress John A III · Campbellsville, KYS/N 47698N9899GWings Over Texas LLC · Denton, TXBuilt 1971 · S/N 17259799N9899HCrimson Aircraft Sales LLC · Tuscumbia, ALBuilt 1981 · S/N 18268098N9899QBrown Richard K · East Falmouth, MABuilt 1975 · S/N 17265843N989CPCivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282116N989CWCardinal Wings Aviation LLC · Buckner, KYBuilt 1976 · S/N 17266884N989RAAvco Patrol LLC · Lyndon, KSBuilt 1997 · S/N 18280035N989SDFlyby Equipment LLC · Factoryville, PABuilt 1957 · S/N 34207N989SPJet Air Inc · Iowa City, IABuilt 1999 · S/N 172S8210
Back to AD 79-10-14 R1