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.

N65BLWhite Craig S · Troy, OHBuilt 2001 · S/N 18281069N65CFSanders David T · Flagstaff, AZBuilt 1962 · S/N 18254365N65DGDeschweinitz Christian R · Anchorage, AKBuilt 1954 · S/N 26210N65DPPilawski Darren · Spring Hill, FLS/N 17257299N65DWNorth Stream Capital LLC · Scottsdale, AZBuilt 1969 · S/N 18052026N65EAPhilbrick Quinn R · Rangeley, MEBuilt 1966 · S/N 1850997N65EBKansas Farm & Ranch In · Seneca, KSBuilt 1977 · S/N R1722331N65FDBarnstormer Leasing LLC · Murfreesboro, TNBuilt 2017 · S/N 18283010N65GVDemski Domenic Ross · Woodbridge, CAS/N 17271252N65HFHorizon Flight Center LLC · Chesapeake, VABuilt 2024 · S/N 172S13138N65JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1977 · S/N 17268591N65KCBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 18281015N65KDNorthwest Wings LLC · Hillsboro, ORBuilt 1974 · S/N 17264565N65KSSauceda Juan B · Austin, TXBuilt 1965 · S/N 18256481N65MArata Steve · Corning, CABuilt 1965 · S/N 15061421N65MMShewbart Keith M · Crystal River, FLBuilt 1969 · S/N 337M0446N65MPWard Gerald · Austin, TXS/N 21057904N65NOlterman Robin L · John Day, ORBuilt 1971 · S/N U20601729N65PKOlson'S Excavating Inc · Cascade, IDBuilt 1966 · S/N 18257491N65PTBs Aviation LLC · Portland, ORBuilt 1976 · S/N 177RG1086N65RGRandolph Clinton A · Bullhead City, AZBuilt 1965 · S/N 15061365N65RHHall Robert · Rapid City, SDBuilt 1977 · S/N 18052869N65SKenyon Ray · Sherburne, NYBuilt 1974 · S/N P3370166N65WBMckamey Robert S · Tullahoma, TNBuilt 1966 · S/N 17254426N65WPWarnken James V · Pleasanton, TXBuilt 1977 · S/N R1722232N66003Nesheim William A · Holderness, NHBuilt 1979 · S/N R1723000N66006Registration Pending · Souderton, PARegistration pendingBuilt 1974 · S/N 15075769N66009Cowan Ronnie C · Glasgow, KYBuilt 1974 · S/N 15075772N6600DMarsh John E · Washington, DCS/N 15072100N6600FSeiger Thomas W · Medford, ORS/N 15063200N6600RDoyles Welding Lc · Phillipsburg, KSBuilt 1979 · S/N 172RG0206N6600TJtf Aviation LLC · River Falls, WIBuilt 1962 · S/N 17249906N6600XBlanton David L · Valley Center, KSBuilt 1960 · S/N 21057600N66010Crane William Jr · Somerville, ALBuilt 2005 · S/N 172S9771N66015Rock Solid Aviation LLC · Lake Charles, LABuilt 1983 · S/N 17275948N66017Engelhardt John · Kingwood, TXFirst renewal noticeBuilt 1974 · S/N 15075778N66018Executive Aviation LLC · Peoria, AZBuilt 1983 · S/N 17275949N6601EBiloff Chet A · Palmer, AKBuilt 1959 · S/N 56101N6601HCanby Pilots Club Inc · Canby, MNBuilt 1975 · S/N 17265503N6601KAir Force Academy Aero Club · Usaf Academy, COBuilt 1980 · S/N 17274218N6601MOptical Aviation LLC · Edmond, OKBuilt 1975 · S/N 18263774N6601RHolmes Donald R · Carlsbad, CABuilt 1979 · S/N 172RG0207N6601THoting John M · Santa Rosa, CAS/N 59001N66021Mcgraw Leasing LLC · Sitka, AKBuilt 1977 · S/N 18052905N66022Pickett Ronald K II · Mc Alpin, FLBuilt 1974 · S/N 15075782N66025Suburban Air Corp · Castro Valley, CAS/N 172S9777N6602CSnip Robert C · Telluride, COBuilt 1980 · S/N 21063926N6602DLand Of Liberty LLC · Seminole, FLS/N 17272889N6602ERivera Joel · Carolina, PRBuilt 1959 · S/N 56102N6602FBeasley Thomas · Fort Worth, TXS/N 15063202
Back to AD 79-10-14 R1