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.

N777MBCullen Maryrose · Longmont, COBuilt 1977 · S/N R1722601N777NTN777nt LLC · Fort Mill, SCBuilt 1975 · S/N 21060972N777NYJohanson Jason M · Groveland, CAS/N U20605051N777PTGrandair Aviation Inc · Grand Ledge, MIBuilt 1976 · S/N 15078720N777RKing Winn K · Gladewater, TXBuilt 1972 · S/N 21059551N777RGLow Matthew N · Clearwater, FLBuilt 1968 · S/N 18258774N777RRChalk 2 Inc · Apple Valley, CABuilt 1977 · S/N 21061729N777SZMullen John J Jr Trustee · Henderson, NVBuilt 1970 · S/N 21059265N777TVTop Ag Inc · Colby, KSBuilt 1977 · S/N 18265360N777TWMcdonald Timothy J · Daytona Beach, FLBuilt 1977 · S/N R1722585N777UMMahlik Michael A · Casco, WIS/N 17275405N777WLAerospace Trust Mangement LLC Trustee · Wilmington, DEBuilt 1970 · S/N 21059376N777WRFoley James V · Houston, TXBuilt 1962 · S/N 18253913N777ZCDiversified Refrigeration Co · Lino Lakes, MNBuilt 1966 · S/N 18256985N7780AWhitmore Jay R · Anchorage, AKBuilt 1957 · S/N 32677N7780EBush Consulting Services LLC · Pensacola, FLS/N 17580N7780FDuquette Stephen R · Fenton, MIS/N 15063880N7780GAero Quest LLC DBA · Olive Branch, MSBuilt 1970 · S/N 17259480N7780KRegistered aircraftBuilt 1976 · S/N 18052729N7780XRegistration Pending · Meridian, IDRegistration pendingS/N 17248280N77812Wildman Gary C Trustee · Germantown, TNBuilt 2005 · S/N 18281549N7781EGibson Paul Trustee · Groveland, CABuilt 2005 · S/N 18281621N7781GKelley Aircraft LLC · Weyers Cave, VABuilt 1970 · S/N 17259481N7781TChouinard Shawn A · Collinsville, OKBuilt 1960 · S/N 47381N7781UKerslake Alex J · Ellensburg, WABuilt 1964 · S/N 17251781N7781XPeraro Thomas A · Brighton, COS/N 17248281N7782FLewis Wayne · Martin, TNBuilt 1966 · S/N 15063882N7782KHaughee Jared · Warsaw, INBuilt 1976 · S/N 18052730N7782THicks Thomas H · Conway, ARS/N 47382N7782XBoucher Roberta Ann · Fredericksburg, VABuilt 1961 · S/N 17248282N7783APhipps Laura P · Midland, TXS/N 32680N7783EMobile Aviation Solutions LLC · Sharpsburg, GABuilt 1959 · S/N 17583N7783FMiller Patrick G · Homer, AKBuilt 1966 · S/N 15063883N7783UEppich Glen M · Kingman, AZBuilt 1964 · S/N 17251783N7784FSelf Edwin C · Columbia, TNBuilt 1966 · S/N 15063884N7784GAll2fly LLC · Atlanta, GABuilt 1970 · S/N 17259484N7784TJustonemore LLC · Fayetteville, ARBuilt 1960 · S/N 47384N7785AZulu Forty One LLC · Anchorage, AKBuilt 1957 · S/N 32682N7785UTwo Farmers LLC · Dumas, ARS/N 17251785N7786GRcm Aviation LLC · North Clarendon, VTFirst renewal noticeBuilt 1970 · S/N 17259486N7786UWooton Donald Wayne · Houston, TXFirst renewal noticeBuilt 1964 · S/N 17251786N7787USageser Scott · Carmi, ILS/N 17251787N7788AChambers Samuel S · Salmon, IDS/N 32685N7788FGerig David J · Woodburn, INBuilt 1966 · S/N 15063888N7788UHoffmeyer Scott D · Carson City, NVBuilt 1964 · S/N 17251788N7788XBowling John D · Bryan, TXBuilt 1961 · S/N 17248288N7789AMersereau David H · Anchorage, AKBuilt 1956 · S/N 32686N7789BMersereau David H · Anchorage, AKBuilt 1960 · S/N 52846N7789FSutton George R · Big Bear City, CABuilt 1966 · S/N 15063889N7789UViolette David A · Medway, MEBuilt 1964 · S/N 17251789
Back to AD 79-10-14 R1