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.

N267HPFlorida Highway Patrol · Tampa, FLBuilt 2002 · S/N 172S9267N267JMomentum Foundation Inc · Tullahoma, TNBuilt 2011 · S/N 1110-2011N267JMMathews Development Co · Santa Rosa Beach, FLBuilt 1999 · S/N T20608132N267MECape Aero LLC · Cape Girardeau, MOBuilt 2000 · S/N 18280774N267MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881365N267MTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1974 · S/N 0005N267RBLearn To Fly LLC · Portal, GABuilt 1967 · S/N 32-40261N267RWKoelzer Galen G · Othello, WABuilt 1964 · S/N 0047N267SNorth Carolina Soaring Association · Zebulon, NCBuilt 1969 · S/N 1486N267WSErvin Andrew · Centennial, COBuilt 1966 · S/N 1000N2680MRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1977 · S/N 28-7890261N2680QTaylor Clarence J · Pipestone, MNBuilt 1977 · S/N 32R-7780261N2680WNielson Michael James · Spanish Fork, UTBuilt 1966 · S/N 1001N2680XN2680x LLC · Mountain Home, ARBuilt 1998 · S/N 18280307N2681TFetty Eric · Burleson, TXBuilt 1971 · S/N 28-7210003N2681WAb Mooney LLC · Durham, NCBuilt 1966 · S/N 3319N26821Rhoden Nathan · Prattville, ALBuilt 1979 · S/N AA5A0740N2682CInternational Air Services Inc Trustee · Carson City, NVS/N 18281648N2682ZEmslie Donis A · West Lafayette, OHBuilt 1978 · S/N 265-78N2683CGrigg Charles G · Pasco, WABuilt 1978 · S/N R18200211N2683TSojourn Flyers Inc · Chebanse, ILBuilt 1971 · S/N 28-7205082N2683WSabagh Steve B · Maricopa, AZBuilt 1966 · S/N 1002N2686TGoddard John · Penokee, KSBuilt 1971 · S/N 28-7205083N2687LA R Preston Holdings LLC · Ontario, NYBuilt 1998 · S/N 18280314N2687THolley Ronald E · Hastings, MIBuilt 1971 · S/N 28-7205093N2687ZSchaefer Richard T · Marble Falls, TXBuilt 1978 · S/N 365-78N2688BScott Fred · Greencastle, INBuilt 1968 · S/N 28-5065N2689WLocke Timothy S · Fort Irwin, CABuilt 1966 · S/N 1006N268BGHuff Holdings LLC · Ashland, KYBuilt 1976 · S/N 28-7690268N268CSInternational Air Services Inc Trustee · Carson City, NVBuilt 2013 · S/N 172S11266N268CTCoast Flight Training And Management Inc · San Diego, CABuilt 2005 · S/N 17281258N268DASpartan Education LLC · Tulsa, OKBuilt 2002 · S/N 4496135N268DMRobinson Michael E · Chandler, AZBuilt 2005 · S/N 170N268EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13506N268FMRunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13268N268HPFlorida Highway Patrol · Tampa, FLBuilt 2005 · S/N T20608579N268JCShaw Melvin · Annapolis, MDBuilt 1978 · S/N R18200213N268MERegistered aircraftBuilt 2000 · S/N 18280776N268MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881366N268RVRegistered aircraftBuilt 2006 · S/N 81313N268ZMewmew Investment II LLC · Palo Alto, CABuilt 2023 · S/N 172S12947N2690CEdwards Zachary · Sylmar, CABuilt 1978 · S/N R18200214N2690QSilva Alberto · Titusville, FLBuilt 1970 · S/N 17259104N2691BPrewitt Scott S · King City, CABuilt 2005 · S/N 046N2691TSilkgate Aviation LLC · Yorba Linda, CABuilt 1971 · S/N 28-7205065N2692CStewart Chalmous · New London, NCS/N R18200215N2692TWingsleasing LLC · Wichita, KSBuilt 1971 · S/N 28-7205072N2693ZCoen Brady · Wiley, COS/N 268-78N2694GInspec Aviation Inc · Schwenksville, PABuilt 1980 · S/N 28-8090230N2694TStubby Wings LLC · Eden Prairie, MNBuilt 1971 · S/N 28-7205085
Back to AD 2006-10-21