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.

N46440Engelskirger Karl D · Valley City, OHS/N 17257270N46442Lott Terence D · Florence, MSBuilt 1968 · S/N 17257272N46448Mac Air Inc · Farmington, MOBuilt 1968 · S/N 17257276N46449Tilma Flying Club Inc · Moscow, IDBuilt 1968 · S/N 17257277N4644ALee Lauren M · West Greenwich, RIBuilt 1956 · S/N 32241N4644CMassmanf Darrel F · Ogdensburg, WIBuilt 1974 · S/N 18502585N4644FBrennan Timothy R Trustee · Mount Pleasant, SCBuilt 1966 · S/N P206-0244N4644JWinslow Francis E III · Raleigh, NCS/N 17273659N4644UWineglass Holdings LLC · Fort Davis, TXBuilt 1983 · S/N 21064797N46457Ostrowski Sven E · Mullica Hill, NJS/N 17257281N4645BJacobs Lydia A · Lincoln, MES/N 31543N4645CEasom William J · Thousand Oaks, CAS/N 25589N4645FScruggs Ken R · Galloway, OHS/N P206-0245N4645KOrange Air Inc · Harbor City, CANon-citizen corporation, flight hours not reportedBuilt 1975 · S/N 18263647N46460Walter Timothy G · Farmersburg, IABuilt 1968 · S/N 17257283N46462Cook Aviation Services LLC · Fargo, NDBuilt 1968 · S/N 17257285N4646ANorth Sixty Taildraggers LLC · Port Ludlow, WABuilt 1956 · S/N 32243N4646BBravo 300 LLC · Coweta, OKS/N 31544N4646CWilliam Michael Moody · Anchorage, AKBuilt 1975 · S/N 18502586N4646HMilton Djana · Lakewood, WABuilt 1981 · S/N 18267847N4646KPloense Justin M · Big Bear City, CAS/N 18263648N46470Registration Pending · St Charles, ILRegistration pendingBuilt 1968 · S/N 17257291N46474Beam 33 Inc · Billings, MTS/N 17257292N4647AAuch Leo R · Scio, ORBuilt 1956 · S/N 32244N4647CConcolor LLC · Shoreview, MNBuilt 1953 · S/N 25591N4647LTerrel Mitchell · Alva, OKBuilt 1966 · S/N 17254642N46484Campisteguy Alexander J · Renton, WABuilt 1968 · S/N 17257298N46486Calimesa LLC · North Las Vegas, NVBuilt 1968 · S/N 17257300N4648CMadhvani Sanjay J · Tucson, AZBuilt 1979 · S/N 21063583N4648ERandall John Kelly · Fremont, OHBuilt 1982 · S/N 18268254N4648FSimmons Daniel A · Huntsville, ALBuilt 1966 · S/N P206-0248N4648XRipp Patrick L · Mineral Point, WIBuilt 1966 · S/N 15064698N46493Brown Michael F · Richford, NYBuilt 1974 · S/N 17264186N46495Hanna Douglas L · Winchester, KYBuilt 1968 · S/N 17257306N46497Tones Trucking Inc · Cassopolis, MIBuilt 1968 · S/N 17257307N4649BNicholson Stephen G · Bayfield, COBuilt 1955 · S/N 31547N4649EStanberry Carl W · Anchorage, AKS/N 18503830N4649QSkyhawk Services LLC · Lake Wales, FLBuilt 1973 · S/N 17261735N4649UMy Holdings Inc · Anchorage, AKBuilt 1979 · S/N U20605028N464CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280856N464CSBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 18283164N464DBCloud James G · Camden, MEBuilt 1973 · S/N 17262328N464ERMustang Sally Aviation LLC · Camden, SCBuilt 2015 · S/N 172S11598N464FVan Bortel Aircraft Inc · Arlington, TXBuilt 2019 · S/N 18283092N464GSHooper Mark · Elko, NVBuilt 1978 · S/N U20604744N464HExecutive Flight Training LLC · Beaufort, SCBuilt 2020 · S/N 18283120N464JTextron Aviation Inc · Wichita, KSS/N 18283360N464KKing Aaron M · Knoxville, TNBuilt 1997 · S/N 18280039N464LC P Holdings LLC · Watertown, SDBuilt 2018 · S/N 18283060N464MASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 18280822
Back to AD 79-10-14 R1