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.

N63647Appalachian Wings LLC · Ellijay, GABuilt 1975 · S/N 15077453N6364BKgnf LLC · Grenada, MSBuilt 1978 · S/N 21062750N6364CSukhakarta Rentals LLC · Cedar Park, TXBuilt 1980 · S/N 21063875N6364DSuburban Aircraft Leasing And Sales LLC · Sylvania, OHBuilt 1979 · S/N 17272750N6364GCarlstadt William A · South Bound Brook, NJBuilt 1970 · S/N 15071864N63650Crain Charles E III · San Antonio, TXBuilt 1975 · S/N 15077455N63651Agricola Joseph D · Brooksville, FLBuilt 1975 · S/N 15077456N63652Tyndall Darryl K · Deep Run, NCFirst renewal noticeBuilt 1975 · S/N 15077457N63653Coker Steve L Jr · Tyler, TXBuilt 1975 · S/N 15077458N63655Van Houten Ronald G · Kalamazoo, MIBuilt 1975 · S/N 15077459N63657French Chris · Anchorage, AKBuilt 1975 · S/N 15077460N63659Droege Robert Michael · Saratoga Springs, NYBuilt 1981 · S/N 17275463N6365BKnopp Steven L · Camano Island, WABuilt 1957 · S/N 34265N6365FRindo David J · Lowell, MABuilt 1979 · S/N 17273203N6365GN6365g LLC · Buckeye, AZBuilt 1970 · S/N 15071865N6365KSchlueter Wayne J · Andover, KSBuilt 1975 · S/N 15077666N6365UPino Carlos R · Santa Fe, NMBuilt 1985 · S/N 21064944N63662Gessert Adam K · Gilbert, AZS/N 15077463N63663Lake Aviation LLC · Murfreesboro, TNBuilt 1981 · S/N 17275465N63664Cabrera Ramon F · Guttenberg, NJS/N 15077465N63665101 Flight LLC · Waterford, MIBuilt 1975 · S/N 15077466N6366AHunsaker Travis J · Salem, ORBuilt 1956 · S/N 33166N6366FDerose Joseph F · Salt Springs, FLBuilt 1979 · S/N 17273204N6366GTownson Charlotte K · Cisco, TXBuilt 1970 · S/N 15071866N6366KCastano Jose R · Sleepy Hollow, NYBuilt 1975 · S/N 15077667N63670Uflyorlando Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1975 · S/N 15077471N63671N63671 LLC · Austin, TXBuilt 1975 · S/N 15077472N63677Weir Ryan Lee · Buckley, WABuilt 1975 · S/N 15077477N63679Goldman Jacob · Bend, ORBuilt 1975 · S/N 15077479N6367AFritz Mathew L · Boise, IDBuilt 1956 · S/N 33167N6367BSmart John H · Chugiak, AKBuilt 1957 · S/N 34267N6367KPethes Ted · Las Vegas, NVS/N 15077668N6367SLogtime Flight LLC · Lancaster, TXBuilt 1967 · S/N 15067167N63681American Patrols Inc · Midland, TXBuilt 1981 · S/N 17275467N6368SMommsen Robert V · Ketchikan, AKS/N 15067168N63694Upper Valley Aero LLC · Hanover, NHBuilt 1981 · S/N 17275470N6369BWilliams James R Trustee · Reno, NVBuilt 1957 · S/N 34269N6369ETeed Brad S · Vancouver, WABuilt 1959 · S/N 46469N636CBN636cb LLC · Bensenville, ILBuilt 2019 · S/N 172S12261N636CMCaelum Et Terra LLC Series B · Evanston, ILBuilt 2021 · S/N 172S12657N636CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281531N636CRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11462N636CXNewton Property Leasing LLC · Greene, IABuilt 1978 · S/N 17271789N636EMAb Prop Plane II LLC · Metairie, LABuilt 2022 · S/N 172S12852N636LSN636ls LLC · Bensenville, ILBuilt 2020 · S/N 172S12474N636RJAirspeed Aviation Associates LLC · Austin, TXBuilt 1998 · S/N 18280273N636SAMustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9636N636WCMcgivern Mark M · Fountain Hills, AZBuilt 1962 · S/N 18253965N63702Smith Brian E Trustee · Richland, WABuilt 1981 · S/N 17275471N6370DMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17272756
Back to AD 79-10-14 R1