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.

N12QWAll Aviation LLC · Tucson, AZBuilt 1984 · S/N 5053N12RDoll John M · Austin, TXBuilt 1976 · S/N 0744N12RDFlying Colors Airparts Inc · Leesburg, FLBuilt 1958 · S/N 24-368N12REWilliams Jeffrey · Georgetown, INBuilt 1982 · S/N EPPLETT-0001N12SDStevens Sam D · Isola, MSBuilt 1973 · S/N 1376N12SFToller Rick L · Crescent City, FLBuilt 1977 · S/N 814N12STWise Ventures LLC · Mooresville, NCBuilt 2006 · S/N 3257412N12TCCb22 Holdings LLC · Price, UTBuilt 1977 · S/N 28-7790417N12TESchwigen Justin R · Alton, ILBuilt 1998 · S/N 1440N12TQWyoming Aeroflight LLC · Laramie, WYBuilt 1994 · S/N 1270N12TRRegistered aircraftBuilt 1991 · S/N 10053N12TZJ H O Enterprises Inc · Carol Stream, ILS/N 61-0259-101N12VRCulver Lane M · Laceys Spring, ALBuilt 1988 · S/N 10058CN12WAIoe Aviation LLC · Kirkland, WABuilt 1994 · S/N 21712N12WPSpradlin Flying Service Inc · Petersburg, TXS/N 1013N12WZNortech Data Services Inc · Wilmington, DEBuilt 2003 · S/N 2206N12XGCommander Aviation LLC · Williamsburg, VABuilt 1977 · S/N 14237N12XLAurora Aviation LLC · Billings, MTBuilt 2004 · S/N 27-0325N12YRHauck Scott · Loveland, OHBuilt 2012 · S/N 5829N12ZVon Gottsegen Erik · Sweet Home, ORBuilt 1976 · S/N 16N12ZFJohnson Ross · Anderson, SCBuilt 2000 · S/N 9912CCN12ZX24-3227 Inc Trustee · Wilmington, DEBuilt 1991 · S/N 24-3227N1300AMann Lee S · Euless, TXBuilt 1966 · S/N 1064N1300PHerzog Gregory L · Star, IDBuilt 2001 · S/N 18068CN13019Plumer Eric · The Plains, VABuilt 1975 · S/N 17702395N1301JMoran Francis W Jr · Augusta, GABuilt 1975 · S/N 301N1302JAtmos Inc · Kapolei, HIBuilt 1975 · S/N 302N1303WPowell Steven J · Fairview, TXBuilt 1963 · S/N 191N13048Plane Fun Inc Tr Trustee · Snellville, GABuilt 1995 · S/N 374N1304DGardners Guns & Mfg LLC · Elk City, OKBuilt 1951 · S/N 19880N1304WBrihn Rhonda J · Waterford, WIBuilt 1963 · S/N 192N1305BTriangle Aviators LLC · Cary, NCBuilt 2007 · S/N 172S10654N1305JMans Thomas S · Oakland, TNBuilt 1975 · S/N 305N13061Kelly Thomas E · Tequesta, FLFirst renewal noticeBuilt 1975 · S/N 17702396N1306CWateractive43 LLC · Auburn, CABuilt 2007 · S/N 172S10655N1306MFreedom Aviation Inc · Lynchburg, VABuilt 2006 · S/N 172S10336N1306W06 Whiskey Partners · Centennial, COBuilt 1963 · S/N 194N1307CHouse Of Raeford Farms Inc · Rose Hill, NCBuilt 2006 · S/N 172S10337N13084Lutz Kelly L · Auburndale, FLBuilt 1976 · S/N 17702397N1309GPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10342N1309WSanford Mark J · Ithaca, NYBuilt 1963 · S/N 197N1309ZReady Aim Flyer LLC · New Castle, DEBuilt 1961 · S/N TD-463N130ACBilco Air LLC · Danville, ILBuilt 1992 · S/N 663-92N130AGWings Over Texas Holdings LLC · Denton, TXBuilt 2024 · S/N 4496578N130BBHatfield Derik L · Mesa, AZBuilt 1979 · S/N 0013N130BNJch Aviation LLC · Midlothian, TXS/N 20110N130BRWilcox Charles R · Discovery Bay, CABuilt 2005 · S/N 2920N130DGDixie Aviation LLC · Pelham, ALBuilt 1972 · S/N 28R-7235127N130DPPlane@Work LLC · Blaine, MNBuilt 1987 · S/N 003N130EOshinuga Anthony A · Valley Center, CABuilt 1940 · S/N 1029
Back to AD 2006-10-21