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.

N2662ARogers Construction Services Inc · Boca Raton, FLBuilt 1998 · S/N 18280331N2662BGjl Aviation LLC · Fort Worth, TXBuilt 1998 · S/N 18280332N2662TPlane Aviation LLC · Camarillo, CABuilt 1971 · S/N 28-7205070N2662WEaton Mark E · Houston, TXBuilt 1966 · S/N 3312N2662ZBidcal Inc · Chico, CABuilt 1998 · S/N 18280338N26630Iasco Flight Training Inc · Redding, CABuilt 1998 · S/N 17280565N2663XAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280643N2664UHill Flying Club Inc · St George, UTBuilt 1998 · S/N 18280298N2665CWindsock Skies LLC · Caldwell, TXBuilt 1978 · S/N R18200201N2666TNess Ronald O · Canyon Lake, CABuilt 1971 · S/N 28-7210002N2667WMartens Steven A · Stanley, NDBuilt 1966 · S/N 670024N2667ZHite Loren E · Fairbanks, AKBuilt 1978 · S/N 264-78N2668TKing Thomas S · Boerne, TXBuilt 1971 · S/N 28-7205092N2668WJarchow John H · Denison, TXBuilt 1966 · S/N 993N2669WAlecci Alexander Drew · Sanford, FLBuilt 1966 · S/N 994N266AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881760N266ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496104N266BBetki Randy A · Grosse Ile, MIBuilt 1958 · S/N 126N266BBJk Air LLC · Duncan, OKBuilt 1999 · S/N T20608082N266DHurricane Mesa Aviation LLC · Hurricane, UTS/N 13017N266DLCampbell Thomas J · Center, TXBuilt 2002 · S/N 25154N266FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020262N266LARaintree Aviation LLC · Mesa, AZBuilt 2012 · S/N 172S11178N266MEGershman Randy · Marshfield, WIBuilt 2000 · S/N 18280772N266MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881364N266SFEastern Stearman Inc Trustee · Leesburg, VABuilt 1969 · S/N 2-29N266SHDirty Bird Helicopters LLC · Boerne, TXBuilt 2007 · S/N 4230N266SPTfs Air LLC · Loveland, COBuilt 2003 · S/N 172S9471N266SWWeddle Scott M Trustee · Albany, ORBuilt 2003 · S/N 70266N266WBBell W Douglas · Grand Haven, MIBuilt 2004 · S/N 80889N266WYReps R1 Drive Unit Co LLC · Helena, MTBuilt 2016 · S/N 3266N266YHogg James R · New Albany, OHBuilt 1968 · S/N 18PN2671WSchwister Daniel Edward · Woodinville, WABuilt 1966 · S/N 3315N2672Q4m Aviation LLC · Orting, WABuilt 1977 · S/N 28R-7737040N2672THilgendorf Blake W · Fairmont, MNBuilt 1971 · S/N 28-7110027N2672WGallatin Aviation Enthusiasts LLC · Fairbanks, AKBuilt 1966 · S/N 3316N2672XBird Nest Aviation LLC · Sheldon, IABuilt 1998 · S/N 18280305N2673TZweig William D · Chesterfield, MOBuilt 1972 · S/N 28-E11N2673WAdolf Charles P · Ocala, FLBuilt 1966 · S/N 996N2674TCosgrove John W · Lake Ariel, PABuilt 1971 · S/N 28-7205075N2674WHough Publishing LLC · Atlanta, GABuilt 1966 · S/N 997N2675DPaige Barry Wayne · Wasilla, AKBuilt 1952 · S/N 20827N2676TMills Nicolas A · Greenwood, NYBuilt 1971 · S/N 28-7205074N2677TDaggett Truck Lines Inc · Frazee, MNBuilt 1971 · S/N 28-7205077N2677WSaunders Charles A · Scott Depot, WVBuilt 1966 · S/N 3318N2678TTekforce LLC · Boca Raton, FLBuilt 1971 · S/N 28-7205078N2678WLansford Company Inc · Lampasas, TXBuilt 1966 · S/N 999N267AAWings Over Texas Holdings LLC · Denton, TXBuilt 2019 · S/N 4496482N267DHInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N 28-8190141N267GSArnold Airplane LLC · North Branch, MNBuilt 1994 · S/N 737-94
Back to AD 2006-10-21