AD 2006-10-21

Registered aircraft · 44,908

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:2006-10-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
  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.

N15TYArneson Kenneth W · Beaverton, ORBuilt 1975 · S/N 150-76713N15USale Reported · Van Nuys, CASale reportedBuilt 1979 · S/N ME-160N15VRCarley Daniel · Center Moriches, NYBuilt 1998 · S/N 21486N15WAG Force Aerobatics LLC · Eugene, ORBuilt 1992 · S/N 5247N15WJFleming Laurence Erik · Salinas, CABuilt 1999 · S/N 824-99N15YMMiller Jeff A · Deering, NHBuilt 1996 · S/N 168N15YPDepartamento De Educacion Prami · San Juan, PRBuilt 1968 · S/N 27-3966N1600UOsprey Holding Company LLC · Foley, ALBuilt 2005 · S/N 172S9905N16019Brown Kenneth D · Port Murray, NJS/N 17702478N1601SRussell Bryan E · Joshua, TXS/N 28-7790057N16021Hill Allen W · La Junta, COBuilt 1976 · S/N 17702479N16023Carr Richard D Trustee · Stockton, MOBuilt 1976 · S/N 17702480N16066Thompson Derek D Jr · Dunkirk, MDBuilt 1976 · S/N 17702482N1608SNew Horizon Aviation Inc · Warwick, RIBuilt 2005 · S/N 172S9907N160AASauerbrey Andreas M · Steamboat Springs, COBuilt 2007 · S/N 2391N160BCPridmore Reginald C · Laughlin, NVS/N 457-2004N160CAPrice Keyth E · Ossian, INS/N S1554N160DPrice Paul L · Lancaster, VABuilt 1966 · S/N 3448N160DSSalcedo Daniel R · Fort Lauderdale, FLBuilt 2004 · S/N 0014N160FUExtreme Attitude Recovery & Aerobatics LLC · Cincinnati, OHBuilt 1983 · S/N 5021N160GMUsda-Aphis-Ws · Cedar City, UTBuilt 2016 · S/N CC18-0082N160JRRhinehart Gerald A Jr · Lordstown, OHBuilt 1996 · S/N 2364N160KTDiscover Resources LLC · Norman, OKBuilt 1976 · S/N AA5A-0115N160LMMino Leonard G · Pueblo West, COBuilt 1958 · S/N 24-79N160MAWells Scott A · Fort Myers, FLBuilt 2001 · S/N 260009N160PTPilot Training Center LLC · Miami, FLBuilt 1978 · S/N 44-7995161N160WBBeach Banners Inc · Jacksonville, FLBuilt 1958 · S/N 55238N160WWBrynelsen Charles R · North Oaks, MNBuilt 2007 · S/N 2384N160XMalolo LLC · San Luis Obispo, CAS/N 500B-1300-115N16134Adibi Saeed · Huntsville, ALBuilt 1976 · S/N 17702485N16137Hines Roger E · Greenville, OHBuilt 1976 · S/N 17702487N1614JCoraggio Joseph · Chandler, AZBuilt 2015 · S/N 03N1615AAnson Air LLC · Sugar Land, TXBuilt 2005 · S/N 172S9910N16185Schwartz David W · Windsor, NYBuilt 1976 · S/N 17702491N16199Allbritton John Mark Trustee · Oakland, TNBuilt 1976 · S/N 17702493N161AMDe Boissard Karen · New York, NYS/N 2161N161BLAirborne Holdings Inc · Midlothian, TXBuilt 1965 · S/N 1551-197N161BWWelch William Ben · Danville, ILBuilt 2005 · S/N 10601N161CMR&J Helicopters LLC · Port Byron, ILBuilt 2016 · S/N 2444N161DSHeffron Neuhold Nicholas A · Honolulu, HIBuilt 1977 · S/N 2136N161FCAps Asset Management Inc · Mesa, AZBuilt 2001 · S/N 133N161GLEdwards Jeffrey L · Port Orange, FLBuilt 1978 · S/N 0814N161JHAllison Daniel S Trustee · Jenner, CABuilt 1991 · S/N 5232N161JLLuebben John R · Fayetteville, GABuilt 1966 · S/N 346N161LMays Stephen W · Carson City, NVBuilt 1971 · S/N 470N161MABarnes Gordon R · Manalapan, NJBuilt 2000 · S/N 3257161N161MRVictor Aircraft Co · Wilmington, DEBuilt 1977 · S/N 27-7754106N161MSBaker Weldon J · Lamesa, TXBuilt 2002 · S/N 60469N161PRegistered aircraftBuilt 1958 · S/N 24-533N161PCSpence Jeffrey · Haskell, OKBuilt 2020 · S/N 40052
Back to AD 2006-10-21