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.

N809EMDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608213N809GTDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608245N809HWDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608248N809KPDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608249N809LNDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608251N809NDDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608219N809PGDepartment Of Homeland Security · Washington, DCBuilt 2003 · S/N 20608190N809QJDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608209N809RHDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608210N809SEDepartment Of Homeland Security · Washington, DCBuilt 2003 · S/N 20608208N809STDiaz Natanael Luna · Toa Baja, PRS/N 17268873N809TTDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608211N809USDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608231N809VADepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608232N80AARegistered aircraftFirst renewal noticeBuilt 1964 · S/N 18051426N80BFAir Future Airways Corp · Miami, FLBuilt 2000 · S/N 172S8611N80CAThomson Ian W · Anchorage, AKBuilt 1952 · S/N 20301N80CRRdp Construction LLC · Sitka, AKBuilt 1980 · S/N U20605548N80DTTerasaka Kotaro · Moab, UTBuilt 1959 · S/N 17052N80FPCarastro Enterprises LLC · Montgomery, ALBuilt 1978 · S/N 17271343N80GWSnyder Michael P · Las Vegas, NVBuilt 1974 · S/N 21060425N80HHoward Roland Dean · San Antonio, TXS/N 15387N80HXAthans Holdings LLC - Series 180 · Lake In The Hills, ILS/N 18053035N80JWMorgan Philip H · Anchorage, AKBuilt 1961 · S/N 18051018N80LULetourneau University · Longview, TXBuilt 2023 · S/N 172S12969N80MTMeloche Michael S Trustee · Hamilton, MTBuilt 1979 · S/N U20605467N80MWOlde North Church LLC · Wilmington, DEBuilt 1976 · S/N 18503092N80NInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N P3370197N80PELakepoint Aviation LLC · Augusta, KSBuilt 2004 · S/N 18281472N80PPN80pp LLC · Titusville, FLBuilt 1966 · S/N 15064997N80RMMcguigan Robert J · Green Cove Springs, FLBuilt 2001 · S/N A1520745N80RXMccord Cheryl · Kuna, IDBuilt 1979 · S/N R1723276N80SGFerland Henry L III · Vidalia, GABuilt 1980 · S/N 21064014N80SMSkyward Aviation Enterprises LLC · Raleigh, NCS/N R172-0187N80WCAir-Quip LLC · Boulder City, NVBuilt 1981 · S/N 18267838N80WTOtter Creek Lodge LLC · Big Timber, MTBuilt 1976 · S/N 18052784N8100SHigh Exposure Inc · Wilmington, DEBuilt 1965 · S/N 15061700N8101LRegistration Pending · Minden, LARegistration pendingS/N 17256301N8101UWeirick Kelly M · Morganton, NCBuilt 1964 · S/N 17252001N8101XBreuer Elizabeth · Horseshoe Bend, IDBuilt 1961 · S/N 17248601N8102ABuck Randall J · Greenfield, INFirst renewal noticeS/N 20954N8102FFerrier Robert Clifford · Lindsay, CABuilt 1966 · S/N 15064202N8102MShannon Michael E · Richland, WAS/N 18264540N8102ZCrestview Estate LLC · Greenwood, SCBuilt 1962 · S/N 205-0102N8103ACronk Kenneth B · Woodrow, COBuilt 1952 · S/N 20955N8103BJafar Farid G · Pine Bluff, ARBuilt 1957 · S/N 29903N8103LSoaring Mrt LLC · Lake Charles, LABuilt 1967 · S/N 17256303N8103ZProsser Joel R · Sacramento, CABuilt 1962 · S/N 205-0103N8104BRomar Mark A · Massillon, OHBuilt 1957 · S/N 29904N8104FDunham John P · Colorado Springs, COS/N 15064204
Back to AD 79-10-14 R1