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.

N201SQThomas John M · Lake Lure, NCBuilt 1977 · S/N 240298N201STTillman Stephen · Jacksonville, FLBuilt 1977 · S/N 24-0201N201SWMccrea Alice · Albuquerque, NMS/N 24-0188N201SZRacoon Aviation LLC · San Antonio, TXS/N 24-0285N201TAAdams Toby R · Paris, TXBuilt 1977 · S/N 24-0291N201TCInternational Lift Planning Inc · Anaheim, CABuilt 1977 · S/N 24-0173N201TDHasenauer Matthew R · North Platte, NEBuilt 1977 · S/N 24-0307N201TEBest Power Inc Trustee · Wilmington, DEBuilt 1977 · S/N 24-0289N201TJPalmetto Moon Light Services LLC · Mount Pleasant, SCBuilt 1977 · S/N 24-0306N201TKUp Aerospace LLC A Series Of · Georgetown, TXBuilt 1976 · S/N 24-0048N201TLPiorkowski Christian E · Pearland, TXBuilt 1977 · S/N 24-0202N201TMTrujillo John Francisco · Newport News, VABuilt 1978 · S/N 24-0388N201TQJackson Zarick · Pembroke Pines, FLBuilt 1977 · S/N 24-0351N201TRAero Nautical Electronics Inc · Starke, FLBuilt 1977 · S/N 24-0279N201TSJacobsen Eric A · Scottsdale, AZBuilt 1977 · S/N 24-0077N201TVHiivala Robert J · Hanover, MNBuilt 1977 · S/N 24-0332N201TWTom Wood Aviation Inc · Fishers, INBuilt 2025 · S/N 172S13294N201TYSingleton Kimberley P · Stuart, FLBuilt 1977 · S/N 24-0322N201TZMayerchak Mark · Mooresville, NCBuilt 1977 · S/N 24-0324N201UAAllard Aviation LLC · Nashua, NHBuilt 1977 · S/N 24-0361N201UBProxima Flight LLC · Spring Lake, MIBuilt 1977 · S/N 24-0362N201UEWoodhams Brian · Wayland, NYBuilt 1977 · S/N 24-0366N201UFReck Robert · Cameron, MTBuilt 1977 · S/N 24-0338N201UGRojemann Nathaniel W · Pass Christian, MSBuilt 1977 · S/N 24-0369N201UJ787 P&G 201 LLC · West Chicago, ILBuilt 1977 · S/N 24-0389N201UKLewis Daniel F · Edgewater, FLBuilt 1977 · S/N 24-0394N201UTRegistered aircraftBuilt 1977 · S/N 24-0313N201UWFlyscotty Development LLC · Gary, INBuilt 1977 · S/N 24-0390N201UXMccallister Randy S · Pulaski, VABuilt 1977 · S/N 24-0391N201UZForrest Dean L · Hales Corners, WIBuilt 1977 · S/N 24-0393N201VBH3 Aero Concepts LLC · Groveland, FLBuilt 1977 · S/N 24-0372N201VELa Brucherie Andrew · Redlands, CABuilt 1978 · S/N 24-0395N201VFTyler Walter M II · Canoga Park, CABuilt 1977 · S/N 24-0344N201VHJt Engineering Inc · Wilmington, DEBuilt 1977 · S/N 24-0397N201VKSandy Cove Inn LLC · Seaside, ORBuilt 1977 · S/N 24-0208N201VLHuxley Jonathan S · San Diego, CABuilt 1977 · S/N 24-0398N201VMGilbert Jeremy · Collinsville, ALBuilt 1977 · S/N 24-0336N201VNPrzebinda Viktor · Boulder, COBuilt 1977 · S/N 24-0248N201VPWascher Larry · Mesa, AZBuilt 1977 · S/N 24-0274N201VRHall Keith M Trustee · Great Falls, MTBuilt 1977 · S/N 24-0349N201VSFoglein Aurel T · Trinity Center, CABuilt 1977 · S/N 24-0318N201VUBlanco James A · El Dorado Hills, CABuilt 1977 · S/N 24-0401N201VVMead Jeffery · Carrollton, TXBuilt 1977 · S/N 24-0175N201WASombric Scott · Okeechobee, FLBuilt 1977 · S/N 24-0406N201WDHunter David G · Marietta, GABuilt 1977 · S/N 24-0269N201WGWolf Dirk R · Troy, MIBuilt 1977 · S/N 24-0250N201WHAllen Joseph P · Coon Rapids, MNBuilt 1977 · S/N 24-0407N201WJGaudet Douglas · Oldsmar, FLBuilt 1977 · S/N 24-0333N201WLWingsleasing LLC · Wichita, KSBuilt 2026 · S/N 172S13570N201WMN201wm LLC · Palmetto, FLS/N 24-0195
Back to AD 2006-10-21