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.

N209KFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12826N209KTMcmaster Wayne R · Jeffersonville, INBuilt 2008 · S/N 165TN209MSLand & Air Surveying Inc · Malibu, CABuilt 1988 · S/N S1303N209MTTerrell Michael A · Canby, ORBuilt 2009 · S/N 71202N209RGSr Aviation Inc · Sarasota, FLFirst renewal noticeBuilt 1971 · S/N 209N209SHPark West Air LLC · Coraopolis, PABuilt 2007 · S/N 4256N20AJTwigg Brett · Lincoln, ALBuilt 1985 · S/N 475N20AZDelta Juliet Wings LLC · Kennesaw, GABuilt 1979 · S/N 28-7911153N20BBlackard William R Jr · Jacksonville, FLBuilt 1976 · S/N 32R-7680387N20BBSteller Air Charter LLC · Jacksonville, FLBuilt 1983 · S/N 31P-8414005N20BGHull Matthew E · Walnut Creek, CABuilt 1984 · S/N GLODFELTY 001N20BQAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13216N20BUN20bu LLC · Champaign, ILBuilt 1977 · S/N 27-7754063N20BWN220kw LLC · Moses Lake, WABuilt 1976 · S/N 32R-7680355N20BZFirst State Aviation Services LLC · Louisburg, NCBuilt 1981 · S/N 62P08818165016N20CEOslick Rochelle · Oxnard, CABuilt 1993 · S/N GLOVER-0001N20CQA-1 Heavy Equipments Corporation · Pembroke Pines, FLS/N 581N20CUCosta Flying Service Inc · Painted Post, NYBuilt 1980 · S/N 172RG0323N20DBLsn Air LLC · Morrison, COBuilt 2004 · S/N T18208331N20DUHardt Alexander · Tempe, AZBuilt 1985 · S/N 529N20DVSharp Robert M Trustee · Jenks, OKBuilt 2016 · S/N CC18-0081N20DXBig Sur USA LLC · Boca Raton, FLS/N 613N20DYBpw Aviation LLC · Huntsville, ALS/N 614N20DZWeathers Air LLC · Longwood, FLBuilt 1986 · S/N 615N20EA4-D Aviation Consulting LLC · Wilmington, DEBuilt 2001 · S/N 007N20EHUnzicker Keith R · Benson, ILBuilt 1966 · S/N 1090N20ELJrhav LLC · Chassell, MIS/N 622N20EMReifert Todd · Louisville, KYBuilt 1981 · S/N 0001N20EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2020 · S/N 172S12513N20ETClear Skies Avionics Inc · Clearwater, FLS/N 621N20EUWerking John William III · New Windsor, MDS/N 628N20FLowden Howard J · Rome, GABuilt 1965 · S/N TD-623N20FKJohnston Brian · Bethany Beach, DES/N 637N20FQJag Capital LLC · Cocoa, FLBuilt 1986 · S/N 638N20FRNorton Justin William · Albuquerque, NMS/N 639N20FSDahm Douglas W · Discovery Bay, CAS/N 23122N20FVRogers Robert D Jr · Keller, TXBuilt 1986 · S/N 642N20FZSharp Randy L · Rocklin, CABuilt 1986 · S/N 644N20GFVerbil Christopher J Trustee · Los Altos, CABuilt 1987 · S/N 645N20GKHashmi Aijaz · Riverside, CAS/N 646N20GUBaldree Christian Blair · Roseville, CAS/N 655N20GWWyatt John B · Culpeper, VABuilt 1977 · S/N 1N20HYTack John A · Wasilla, AKBuilt 1998 · S/N 2001N20JBBastian Richard L · Burns, WYBuilt 1974 · S/N 1-0031N20JMWaeltz Mark A · Lantana, FLBuilt 1967 · S/N 28-4393N20JZWest William D · Newton, NCBuilt 1986 · S/N 652N20KGAdspitalny LLC · Waynesville, MOBuilt 1986 · S/N 668N20KLBuell Kenneth B · Port Orange, FLBuilt 1986 · S/N 669N20KMMozur Matthew Allen · Danvers, MABuilt 1985 · S/N 558N20KNShaw William C · Carmel, NYS/N 682
Back to AD 2006-10-21