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.

N250WYBrawley David N · Fort Wayne, INBuilt 2015 · S/N 3250N250YZAtp Aircraft 2 LLC · Wilmington, DEBuilt 2015 · S/N 172S11608N250ZMedic Choppers LLC · Springdale, ARBuilt 2018 · S/N 1223N2510KFugate Sandra S · Louisville, KYBuilt 1989 · S/N 877N2510MYonder Corp · Wilmington, DEBuilt 1979 · S/N 27-7954070N2510XRegistration Pending · West Hartford, CTRegistration pendingBuilt 1985 · S/N 32-8606001N2510ZCherry Hill Aviation Inc · Freetown, INBuilt 1977 · S/N 256-77N25110Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13287N25111Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13290N25112Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13293N25113Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13296N25114Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13298N25115Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13299N25116Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13300N25118Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13302N2511WArcher Ht LLC · Noblesville, INBuilt 1973 · S/N MC-172N25121Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13306N25123Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13312N251251 Ace Distributers Inc · Arlington, WAS/N 962N25126Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13313N25129Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13319N2512RMartin Randolph · Springfield, ILBuilt 1989 · S/N 913N2512WMonroe Judy L · Keller, TXBuilt 1973 · S/N MC-174N2512ZPlane Old Fun LLC · Mckinney, TXBuilt 1977 · S/N 334-77N25130Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13320N25132Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13321N25135Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13327N25136Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13330N25139Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13333N2513QWare Joseph B · Angleton, TXBuilt 1991 · S/N 4406LCN2513WDaniel Raymond C III · Newborn, GABuilt 1973 · S/N MC-171N25141Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13336N25143Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13337N25145Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13338N2514WFalandys David L · Port Orange, FLBuilt 1973 · S/N MC-178N25150Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13339N25152Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13342N25153Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13345N25157Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13348N25158Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13351N2515WRegistered aircraftS/N MC-187N25160Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13354N25161Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13357N25163Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13360N25167Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13363N2516QKris Noone Air LLC · Wilmington, DES/N 889N2516W4 C'S Aviation LLC · Larose, LABuilt 1973 · S/N MC-188N2516ZBig Sea Enterprises Inc · Wilmington, DEBuilt 1980 · S/N 27-8054039N25170Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13366N25171Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13368
Back to AD 2006-10-21