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.

N610AMSwaz Aviation LLC · Mesa, AZBuilt 1977 · S/N 17270193N610EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12711N610HMGadberry & Graham Inc · Baton Rouge, LABuilt 1973 · S/N 18262128N610HPValor View Aviation LLC · Midland, TXBuilt 1981 · S/N 172RG0892N610KCU S Imaging Flight Ops LLC · Bartow, FLBuilt 1981 · S/N 21064258N610MMMaxq Composites LLC · Oxford, MEBuilt 1968 · S/N 337-0961N610MVCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 18267413N610SLTen Hi Flyers Inc · Denver, COS/N 18267376N610SPPocket Rocket LLC · San Francisco, CABuilt 2000 · S/N 172S8591N61102R&G Leasing Llp · Waterford, WIS/N 18504108N61104Backwoods Air LLC · Caro, MIBuilt 1969 · S/N 15070803N61105Dorsey Sage · Bend, ORBuilt 1973 · S/N U20602063N61108Umrysz Jeffrey E · Mystic, CTBuilt 1969 · S/N 15070807N6110BRansom Bradley D · Flagstaff, AZBuilt 1957 · S/N 34110N6110FKilmer Scott D · Fort Pierce, FLBuilt 1968 · S/N 21059010N6110GHigh Exposure Inc · Wilmington, DEBuilt 1969 · S/N 15071610N61110Veit Brett Allen · Willis, TXS/N 15070809N61112Ralph Joshua C · Wichita, KSS/N 15070811N61114Thomas O Bailey · Sutton, NDBuilt 1969 · S/N 15070813N61119Small Aviation No 3 LLC · Villa Rica, GABuilt 1980 · S/N 18504110N6111NMcgyver Airshows LLC · Wilmington, DEBuilt 1980 · S/N 18267788N6111TAllen Trevor · Richmond, KYBuilt 1964 · S/N 15060811N61120Jstream Lc · Sheridan, WYBuilt 1969 · S/N 15070814N61123Starnes Robert D · Lavonia, GABuilt 1969 · S/N 15070816N61126Roth Jason G · Seattle, WABuilt 1969 · S/N 15070819N61127Mcgill Phil · Huntsville, ALBuilt 1969 · S/N 15070820N61129Jones Flying Service LLC · Pulaski, TNS/N 15070822N6112ABarreto Manufacturing Inc · La Grande, ORS/N 21063498N6112EMcintire John R · Haymarket, VABuilt 1958 · S/N 46212N6112FPcb Inc · Paradise, CAS/N 21059012N6112KNordby Tyler D · Herman, MNBuilt 1975 · S/N 15077532N6112TSnell Matthew · Ackerly, TXBuilt 1964 · S/N 15060812N61130Registration Pending · Wilmington, DERegistration pendingBuilt 1969 · S/N 15070823N61131Anderson Jerry · Vacaville, CABuilt 1969 · S/N 15070824N61132Whithaus Douglas A · Panama City, FLBuilt 1969 · S/N 15070825N6113EPlane Old LLC · Bristol, VTBuilt 1958 · S/N 46213N6113FOrmsby Engineering & Aviation LLC · Georgetown, INBuilt 1975 · S/N 18264116N6113GPratt Aviation Services Inc · Anchorage, AKBuilt 1969 · S/N 15071613N6113RColorado Northwestern Community College · Rangely, COBuilt 1979 · S/N 172RG0086N6113VLegacy Lsa LLC · Plainview, TXBuilt 1980 · S/N 172RG0581N61140Johnson Darryl W · Fowler, COBuilt 1969 · S/N 15070831N61141Holmes Meg C · Winterport, MEBuilt 1969 · S/N 15070832N61143Hedlund Wesley H · Newburgh, MEBuilt 1969 · S/N 15070834N61144Schenk Flight Service LLC · Ainsworth, NEFirst renewal noticeBuilt 1969 · S/N 15070835N61145N61145 LLC · Seattle, WAS/N 15070836N6114RJstream Lc · Sheridan, WYS/N T210-0014N6114TThompson Matthew K · Tuscaloosa, ALBuilt 1964 · S/N 15060814N61152Cunneen Regan M · Vista, CABuilt 1969 · S/N 15070841N61155Smith Jacques F · Anchorage, AKS/N 18504114N61156Williams Tommy J · San Angelo, TXBuilt 1969 · S/N 15070845
Back to AD 79-10-14 R1