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.

N214HRSchaetzel Paul · New Meadows, IDBuilt 2025 · S/N 345N214HSDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1975 · S/N 27-7654014N214JADer Aviation LLC · Dover, TNS/N 3122N214JC214 Mooney LLC · Boca Raton, FLBuilt 1978 · S/N 24-0706N214JDMilngavie LLC · Plano, TXBuilt 2006 · S/N 20416N214JPTop Flight Leasing LLC · Frankfort, ILBuilt 1994 · S/N 3213083N214LE3 Weens LLC · Hoschton, GABuilt 2004 · S/N 18281416N214LMHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 44-7995053N214MHShadow Ventures LLC · Chesapeake, VAS/N T20608214N214MKMargheritis Alex F Trustee · Saugus, CABuilt 2007 · S/N 81855N214RLlano Charles · Lakeland, FLBuilt 1977 · S/N 32R7780522N214RAJw Aero Holdings Inc · Canandaigua, NYBuilt 1976 · S/N 28-7690440N214RRReiff Robert P · Fort Atkinson, WIBuilt 2008 · S/N 2646N214SHSiu Ena · Reno, NVBuilt 1963 · S/N E189N214TBFontaine Troy N · Niceville, FLBuilt 2010 · S/N 71561N214TJVector Aeromedical Services LLC · Smithfield, NCBuilt 1979 · S/N R18201275N214YRutigliano Peter J · Harrington Park, NJS/N MB1N21500Cal Aggie Flying Farmers Inc · Davis, CABuilt 1978 · S/N 44-7995055N2150BGreen Head Flight Services LLC · Bemidji, MNBuilt 1979 · S/N 32R-7987031N2150JKing Mark A · Nolensville, TNBuilt 1978 · S/N 28-7911064N2150KCarey David John II · Mccall, IDBuilt 2003 · S/N T20608407N2150RChalkley Benjamin G · North Liberty, IABuilt 1969 · S/N 28-5471N2150TBecker Brian C · Fort Dodge, IABuilt 1971 · S/N 28-7105165N2150UFifty Uniform LLC · Wilmington, DEBuilt 1963 · S/N 306N2151WKimm Inc · Mocksville, NCBuilt 1974 · S/N M-1531N2151XWcps Aviation LLC · Marietta, GABuilt 2003 · S/N 18281233N2151YMtjc Services LLC · Chester, WVBuilt 2003 · S/N T18208207N2152SMoore Aviation Inc · Beaver Falls, PABuilt 2003 · S/N 172S9444N2152UBrantly Flyers LLC · Aurora, ORFirst renewal noticeBuilt 1963 · S/N 310N2152VJameson Paul E · Palm Coast, FLBuilt 2003 · S/N 172S9445N21531Hans Nelson & Sons Nursery Inc · Boring, ORBuilt 1957 · S/N 18-5496N21538Keyser Soze LLC · Vancouver, WABuilt 1998 · S/N 27-0255N2153AAcuna Edward DBA · Pearland, TXBuilt 2003 · S/N 172S9448N2153CReed Matthew E · Palmerton, PABuilt 1978 · S/N 17702742N2153NEagle Air US Inc · Eau Claire, WIBuilt 1979 · S/N 32R-7987096N2153TFit Services LLC · Gladwin, MIBuilt 1971 · S/N 28-7205003N2153VGoro Sky Aircraft LLC · Lino Lakes, MNBuilt 1999 · S/N 27-0272N2154EOtto Sheldon · Scottsdale, AZBuilt 1978 · S/N 32R-7985038N2154FGentile Nicholas J · Spring Grove, PABuilt 1978 · S/N 28-7990203N2154JLabrum Jack V · Prescott, AZBuilt 2003 · S/N 172S9451N2154RSydenstricker Gregg Scott · Toughkenamon, PABuilt 1969 · S/N 28-5472N2154WThompson Rodney D · Texarkana, ARBuilt 1974 · S/N M-1533N2154XVital Sync LLC · Lakeway, TXS/N 27-0243N2155HHarlan Eric E · Columbus, MSBuilt 1978 · S/N 32-7940016N2155JSlickhorns LLC · Reno, NVS/N T18208209N2155TFeltmeyer Rita Suzanne · Foley, ALBuilt 1971 · S/N 28-7205005N21567Glance John A · Acton, CABuilt 1979 · S/N 28-7911161N2156BTassmanian Aircraft LLC · Middletown, DEBuilt 1978 · S/N 44-7995100N2156EMaarouf Dan H · Taylor Village, TXBuilt 1978 · S/N 32R-7987062N2156NTerryair LLC · Missoula, MTBuilt 2003 · S/N T20608409
Back to AD 2006-10-21