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.

N8167LVan Pelt Wilbur F · Seattle, WABuilt 1967 · S/N 17256367N8167QCedar Pine Construction Inc · Sturgis, SDBuilt 1975 · S/N U20603099N8167SReid Bryce · Oklahoma City, OKBuilt 1965 · S/N 15061767N8167TSouthern Sky LLC · Henderson, NVBuilt 1960 · S/N 17556867N8167XAbel Jacob · Bland, MOBuilt 1961 · S/N 17248667N81689Feisthamel Robert R · Mount Vernon, MOBuilt 1965 · S/N 18256235N8168ADuell Levi D · Kodiak, AKBuilt 1952 · S/N 25020N8168BJacobs Dennis A · Rochert, MNBuilt 1957 · S/N 29968N8168USale Reported · Three Rivers, MISale reportedBuilt 1976 · S/N 15077905N8169AVetterli Gary R · Monroe, WIBuilt 1952 · S/N 25021N8169FRegistration Pending · Parker, KSRegistration pendingBuilt 1966 · S/N 15064269N8169LApex Flight Training LLC · Houma, LABuilt 1967 · S/N 17256369N8169TPerry Edward Glen Trustee · Ozark, ARBuilt 1960 · S/N 17556869N8169UThorn Mark · Vashon, WABuilt 1964 · S/N 17252069N8169VNelson Robert L · Fargo, NDBuilt 1968 · S/N 188-0419N8169XHenderson George · Fresno, CABuilt 1961 · S/N 17248669N816CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281251N816EPFlight Leasing Corp · Wilmington, DEBuilt 2016 · S/N 172S11724N816EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12822N816FATemm 2000 Inc · Arcola, ILBuilt 2002 · S/N 18281116N816HAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1999 · S/N 17280825N816JHIndy Aviation LLC · Carmel, INBuilt 2001 · S/N 18280982N816KSKansas State University · Salina, KSBuilt 2025 · S/N 172S13394N816KWChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 172S10601N816LRegistration Pending · Anderson, SCRegistration pendingBuilt 1968 · S/N 17256833N816LGGray James · Jupiter, FLBuilt 1977 · S/N 17268592N816RARochester Air Center LLC · Canandaigua, NYBuilt 1979 · S/N 17272388N816RDHoffman Aeronautics LLC · Sedalia, COBuilt 2023 · S/N 172S12987N816SWUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2007 · S/N 172S10576N816TRGood Day Holdings LLC · Sheridan, WYBuilt 2022 · S/N 18283173N817Naumann Scott Trustee · Arroyo Grande, CAS/N 18052844N81708Adventist World Aviation Inc · Wilson, NCS/N 18260156N8170BMelechin David H · Los Angeles, CAS/N 29970N8170QMerkes Dennis R · Soldotna, AKBuilt 1952 · S/N 25412N8170TThorn Walter W · Guilford, VTS/N 17556870N8170UFields William B · Climax, NCBuilt 1964 · S/N 17252070N8170XWhittington Melinda Sara Secrest · Columbus, OHBuilt 1961 · S/N 17248670N8170ZJones Kevin C · Leander, TXBuilt 1962 · S/N 2050170N8171BByker Robert L · Porterville, CABuilt 1957 · S/N 29971N8171LSam Aviation LLC · Long Beach, CAS/N 17256371N8171SLeavitt Adam · Boulder City, NVS/N 15061771N8172AWood Thomas A · Salome, AZBuilt 1952 · S/N 25024N8172FButler Donald S · Oak Ridge, NCBuilt 1966 · S/N 15064272N8172UPrice Paul S · Camano Island, WABuilt 1964 · S/N 17252072N8172VStanford Jay J · Kingsland, GAS/N A1500553N8172XVital Twyla J · Seguin, TXBuilt 1961 · S/N 17248672N8173BBetter Air Service LLC · Dailey, WVBuilt 1957 · S/N 29973N8173ESky Equity LLC · Woodbury, MNBuilt 1978 · S/N 17272147N8173FJohnson Jacob A · Shawnee, OKS/N 15064273N8174BSmith Michael D · King George, VABuilt 1957 · S/N 29974
Back to AD 79-10-14 R1