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.

N180SVHarris Carl B · Oakland, MIS/N 200-53N180TDHaley Ron Dr · Eugene, ORBuilt 1999 · S/N 28011CN180TTHigar Air Service Inc · Redlands, CABuilt 1979 · S/N 6-7501N180VASmith Trevor A · Justin, TXBuilt 2002 · S/N 897N180VBPersons Richard A · Arroyo Grande, CABuilt 2003 · S/N 5307N180VMMarshall Glen E · Capitola, CABuilt 2007 · S/N 47014TN180WPPietsch Warren A · Minot, NDBuilt 1980 · S/N XT-1N180XCGilbert James C Trustee · North Plains, ORBuilt 2016 · S/N CC19-0013N180XXDana Glen A · Kewanee, ILBuilt 1996 · S/N 0072N1810SSwift Current Resources LLC · Billings, MTS/N T18208433N18129Loftics LLC · Kennewick, WABuilt 1976 · S/N 17702530N1812EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12168N18159Beck Thomas G · Walled Lake, MIBuilt 1976 · S/N 17702534N1815UJanson James A · Eagle, IDBuilt 2005 · S/N T18208434N1816ZWestern Anesthesia Assn · Richland, WABuilt 1981 · S/N M-232N18174Connell William J · Woodinville, WABuilt 1976 · S/N 17702535N1817EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12169N1817TR J Services LLC · Centerton, ARBuilt 1971 · S/N 28-7105142N1818RSideline Services LLC · Pearland, TXBuilt 1978 · S/N R18200572N1818TCopp Gary P · Carson City, MIBuilt 1971 · S/N 28-7105143N1819BDudinsky Todd M · Eagle River, AKS/N 20008CN1819DSpeedcraft Industries LLC · Port Jefferson, NYBuilt 2020 · S/N 1188-2020N1819GRandall Robert N Jr · Burnsville, MNBuilt 1983 · S/N R182-01819N181AHightower Andrew · Saint Paul, MNBuilt 2003 · S/N 60280N181AFSmoketown Helicopters LLC · Smoketown, PABuilt 2010 · S/N 2100N181AKWeflen Arvid W · Fairbanks, AKBuilt 1992 · S/N W1991N181AVElkins Pilots Club · Elkins, WVBuilt 1979 · S/N 287990269N181BHAeronation Aircraft & Exotics LLC · Lewes, DEBuilt 1982 · S/N 28-8390003N181CCrume Christopher C · Englewood, FLBuilt 1960 · S/N TD-440N181DJNew England Aviation LLC · Plainville, CTBuilt 1977 · S/N 28-7790415N181DMNolan John R · Colorado Springs, COFirst renewal noticeBuilt 2001 · S/N M002N181DP181dp Aircraft Leasing LLC · Spanish Fork, UTS/N 28R-7335246N181DSBuckingham Michael J · La Jolla, CABuilt 2004 · S/N 40.403N181FATriangle Aviators LLC · Cary, NCBuilt 1983 · S/N 288390062N181FCFlightstar Corp · Savoy, ILBuilt 2000 · S/N 2843316N181GBBartel Gary W · Tucson, AZBuilt 1979 · S/N 28-7990275N181GPPilots Flying School LLC · Manalapan, NJBuilt 1984 · S/N 28-8490061N181GSTravel Services LLC · Metropolis, ILBuilt 2006 · S/N T18208499N181HEOzziac Enterprises Inc · Huron, OHBuilt 1988 · S/N 2890078N181KCGillette Investing LLC · Sioux City, IAS/N 32R-8129055N181LEast Atlantic LLC · Helena, MTS/N 20001CN181LSLee Jerry R · Fresno, CABuilt 1999 · S/N 2843227N181MBSpitzer Helicopter LLC · Woodland Hills, CABuilt 2016 · S/N 2425N181MECoastal Marine Engine Inc · Seattle, WABuilt 2000 · S/N T20608182N181MHHurd Mark A · Bono, ARBuilt 1979 · S/N 28-7990279N181MJTrizzino James · North Pole, AKBuilt 1997 · S/N 25014CN181MRAverett University · Danville, VABuilt 1999 · S/N 2843223N181MWCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1997 · S/N 17280181N181PDAnderson Christopher · Wilmington, NCBuilt 1978 · S/N 28-7890462N181PGSkybound Aviation LLC · Kernersville, NCBuilt 1977 · S/N 28-7790584
Back to AD 2006-10-21