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.

N24246Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13147N24247Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13148N24249Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13149N2424FPerformance Aviation Services LLC · Belmont, OHBuilt 1964 · S/N 28-2117N2424HAtom Air LLC · Creekside, PABuilt 2023 · S/N 1N24251Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13150N24256Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13151N24257Career Track I LLC · Wilmington, DEBuilt 2024 · S/N 172S13152N24258Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13153N24259Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13154N2425AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496252N24262Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13156N24263Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13157N24265Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13158N24267Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13160N24268Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13161N2427RFalcon Flight Squadron Inc · Los Angeles, CABuilt 1969 · S/N 28-5620N2427UGalante Anthony R · Saint Clair, MIBuilt 1979 · S/N 28-8090044N24280Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13183N24281Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13185N24283Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13186N24285Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13188N2429RJones Adam · Fairbanks, AKBuilt 2000 · S/N T20608161N2429TKlassen William Peter · Davis, CABuilt 1976 · S/N 28-7690390N242AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881732N242ABBrankov Branimir · Naples, FLS/N 0678N242AFAlagar Volare LLC · Anna, TXBuilt 2003 · S/N 18281183N242AKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2011 · S/N 172S11091N242AMZike Jay N · Lindsay, CABuilt 2003 · S/N 2242N242AURunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13204N242BCElemental Aviation Lc · Wichita, KSBuilt 2011 · S/N 534-2010N242BDDouglass Bryan C · Missoula, MTBuilt 2011 · S/N 40084N242BWLasensky David W · Newtown Square, PAS/N 10214N242CBHarte Mike · Lone Star, TXBuilt 1978 · S/N 24-0459N242CCRecreational Management Inc · Mount Ida, ARBuilt 1997 · S/N 3246095N242CDManly Anderson J · White Salmon, WABuilt 1985 · S/N 1N242CMZlin Parts America LLC · Elmwood, WIBuilt 1994 · S/N 0661N242CPBeste Robert K · Sauk Centre, MNBuilt 1978 · S/N 24-0715N242DCRedtail Aviation Services LLC · Inglewood, CABuilt 1994 · S/N 0668N242DFForce Dave Jr · Glenwood Springs, COBuilt 2005 · S/N 1N242DGWing Over Aerobatics LLC · Weirsdale, FLBuilt 1995 · S/N 0687N242DKInter Island Yachts Inc · Rncho Pls Vrd, CABuilt 1995 · S/N 0689N242DSSneed Jason C · Spanish Fork, UTBuilt 1997 · S/N 001N242DTSherlock William H · Greenbrae, CABuilt 1997 · S/N LRC-1N242EBEb Marine LLC · Riviera Beach, FLBuilt 1967 · S/N 32-40229N242EPEpic Aviation Inc · New Smyma Beach, FLBuilt 2024 · S/N 172S13243N242EX242ex LLC · West Palm Beach, FLS/N 32-7940234N242GT25125 Inc · Wilmington, DEBuilt 2001 · S/N 2042N242HSpruce Creek Tiger LLC · Port Orange, FLBuilt 1977 · S/N AA5B0514N242HRShine Dylan · Jupiter, FLBuilt 1998 · S/N 159
Back to AD 2006-10-21