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.

N9804JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1975 · S/N A1500613N9804TRussell Michael K · Sprakers, NYBuilt 1960 · S/N 47604N9805GSell Edwin D · Woodbury, PABuilt 1971 · S/N 17259705N9805TNorman Ronald E · Lopez Island, WABuilt 1960 · S/N 47605N9806EMccullough John D · Maize, KSBuilt 1985 · S/N 18268448N9806GDonohue Denis J · Montvale, NJBuilt 1971 · S/N 17259706N9806XWelliver Charles Kimmel Jr · Staunton, VABuilt 1961 · S/N 185-0006N9807GPoshak Jay M · Ely, MNS/N 17259707N9807HMid Eastern Specialties Ltd · Wilmington, DEBuilt 1981 · S/N 18268037N9807VLazy T Aviation LLC · Ashland, NEBuilt 1966 · S/N 188-0057N9808HThiel Av LLC · Lewistown, MTBuilt 1981 · S/N 18268038N9808JPtosis LLC · Fair Oaks, CABuilt 1980 · S/N 17273919N9808TGilmer Randy G · Nickelsville, VABuilt 1960 · S/N 47608N9808XKeller Matthew Charles · Wasilla, AKBuilt 1961 · S/N 185-0008N9809GMcclendon Jon L · Kilgore, TXBuilt 1971 · S/N 17259709N9809HHumphries Steve J · Raleigh, NCBuilt 1981 · S/N 18268039N9809JRies Roger W · Franklin, INS/N A1500618N980CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280213N980LKmq Data Acquisitions LLC · Chugiak, AKBuilt 1973 · S/N 18262273N980SCSky Horse LLC · Santa Cruz, CABuilt 1982 · S/N 21064774N980SPFisher Stables And Arena Inc · Gladewater, TXBuilt 1999 · S/N 172S8182N980TAFierling Lennard W · Colton, ORBuilt 1961 · S/N 17248800N9810GAir America Flight Center LLC · Daytona Beach, FLBuilt 1971 · S/N 17259710N9810HLoos Gregory S · Boscobel, WIBuilt 1981 · S/N 18268040N9810JBradley Eric Leon · Anthony, NMBuilt 1976 · S/N A1500619N9810TWall Jeffrey L · Goffstown, NHBuilt 1960 · S/N 47610N9811HArnaud Eldon · Fort Lauderdale, FLBuilt 1960 · S/N 21057667N9811JJones Mark D · Corsicana, TXBuilt 1975 · S/N A1500620N9811VSteffek Mark E · Alturas, CABuilt 1974 · S/N 17264511N9811ZBlack Hawk Brothers LLC · Lakeland, FLBuilt 1982 · S/N U20606674N98120Blue River Aviation LLC · Palmer, AKBuilt 1984 · S/N 17276260N98125Western Reserve Flight Center Inc · Mc Donald, OHBuilt 1984 · S/N 17276261N9812BPavco Inc · Gig Harbor, WABuilt 1982 · S/N 172RG1046N9812GWhitfield Robert O Jr · Hurdle Mills, NCBuilt 1974 · S/N 18801607N9812JMelbourne Flight Training LLC · Melbourne, FLBuilt 1980 · S/N 17273920N9812TBucks Flight Academy LLC · Cashion, OKS/N 47612N9812XSmith James M · Fitchburg, WIBuilt 1961 · S/N 1850012N9813BTsiper Evgueni · Eagan, MNBuilt 1982 · S/N 172RG1047N9813ER&L Enterprise Group LLC · Wilmington, DEBuilt 1975 · S/N 18263919N9813HDowney Corp · Cornwall, VTS/N 18268042N9813LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276616N9813THenley Enterprises Inc · Mangonia Park, FLBuilt 1960 · S/N 47613N9813VArf Corporation · Brooklyn, NYBuilt 1974 · S/N 17264512N9814GNoble Jeremy · Stanwood, WABuilt 1977 · S/N U20603831N9814TWickizer Stephen W · Knoxville, TNBuilt 1960 · S/N 47614N9815GKenmore Air Harbor LLC · Kenmore, WABuilt 1971 · S/N 17259715N9815HAnderson Joseph Richard · Lewiston, IDBuilt 1981 · S/N 18268044N9815LWestosha Flying Club Inc · Kenosha, WIBuilt 1986 · S/N 17276618N9815ZSilver Creek Aviation Services · Fort Worth, TXBuilt 1982 · S/N U20606678N9816EArizona Air Salvage · Phoenix, AZBuilt 1985 · S/N 18268450
Back to AD 79-10-14 R1