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.

N5339DTang Hong-Ming · San Dimas, CABuilt 1979 · S/N 17272528N5339HBering Capital LLC · Anchorage, AKBuilt 1975 · S/N 17265407N5339KNordell Kent D · Staples, MNBuilt 1980 · S/N 17274071N5339MM&M Management Group LLC · Englewood, COBuilt 2003 · S/N 172S9359N5339NMaine State Police · Augusta, MES/N 18267656N533BMGray Ronald P · Glendale, AZBuilt 1999 · S/N 172S8340N533KAKamaka Air LLC · Honolulu, HIBuilt 1973 · S/N 20700216N533KSKent State University · Stow, OHBuilt 2012 · S/N 172S11240N533SJLns LLC · Wichita, KSBuilt 1978 · S/N 17271533N533TDChristopher Schultheis Inc · Colton, WABuilt 1962 · S/N 18253879N53402Anvab Inc DBA · Concord, NHBuilt 1981 · S/N 17274743N5340CCustis James G · Friday Harbor, WABuilt 1950 · S/N 15460N5340TRundell Lanny · Winnsboro, LABuilt 1964 · S/N 17251240N5340XAgvest LLC · Abingdon, VABuilt 2003 · S/N 18281207N5340YCripe Michael L · San Luis Obispo, CABuilt 1980 · S/N 21064173N53417Eastern Cincinnati Aviation Inc · Batavia, OHBuilt 2003 · S/N 17281162N53418N53418 LLC · Orlando, FLBuilt 1974 · S/N 33701611N5341HHoffman Calhoun E · Barnwell, SCBuilt 1975 · S/N 17265408N53420Kropp Christian Trustee · Azle, TXBuilt 1974 · S/N 33701613N5342CPig Aero LLC · Aurora, ILBuilt 1950 · S/N 15565N5342DCornell Timothy R · Hartland, WIS/N 17272531N5342QBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281153N5342SFranco Gloria J · Las Vegas, NVS/N 337-0442N5342TLima-001 LLC · Muscatine, IABuilt 2003 · S/N 172S9360N5342YAmeriflyers Of Texas Inc · Addison, TXBuilt 2003 · S/N 172S9361N53434Caswell Jeff S · Durham, CABuilt 1974 · S/N 33701621N53437Vineyard Eddie E · Wapello, IABuilt 1981 · S/N 17274749N5343BSkydive Moab LLC · Moab, UTFirst renewal noticeBuilt 1956 · S/N 33343N5343DHusnik Brad M · Forest Lake, MNBuilt 1958 · S/N 50241N5343RMcmahon Michael E · Porterfield, WIBuilt 1965 · S/N 17252871N53440Air Spacers Inc · Santa Monica, CABuilt 2003 · S/N 172S9365N53449Hyde Russell M · Rutherfordton, NCS/N 33701631N5344CThomas Robert S · Caddo Mills, TXBuilt 1948 · S/N 18529N5344DAirgo Inc · Centralia, ILBuilt 1979 · S/N 17272532N5344FWingsleasing LLC · Wichita, KSS/N 172S9363N5344HA&F Aviation Services LLC · Collierville, TNBuilt 1975 · S/N 17265409N5344KBoeing Employees Flying Assoc · Renton, WABuilt 1980 · S/N 17274074N5344QGraber Quinten R · Brooksville, MSS/N 15073244N5344RMoxley Michael D · Spearfish, SDBuilt 1965 · S/N 17252872N53456Amelia Reid Aviation LLC · San Jose, CABuilt 1981 · S/N 17274754N5345QRegistered aircraftBuilt 1972 · S/N 15073245N5345TBerrong Jimmy L Sr · Dahlonega, GABuilt 1964 · S/N 17251245N5345UMidwest Avtech Inc · South Barrington, ILS/N 18281210N53460L & W Leasing LLC · Smyrna, TNBuilt 2003 · S/N 172S9351N53463Fara Nick · San Anselmo, CABuilt 1981 · S/N 17274758N53468Maya Aircraft Holdings LLC · Lee, NHBuilt 2003 · S/N 172S9394N5346BSale Reported · Jasper, TXSale reportedS/N 33346N5346DBoldflight LLC · Greenwood, INBuilt 1979 · S/N 17272534N5346EOsprey Holding Company LLC · Foley, ALBuilt 1977 · S/N 17269573N5346KUsaeroflight LLC · Greenville, SCS/N 17274075
Back to AD 79-10-14 R1