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.

N202PMIrons Gregory B · Nixa, MOBuilt 1967 · S/N 670440N202RDHigh Alpha Aero LLC · Wilmington, DEBuilt 1997 · S/N G2020021N202RJAydelott James D · Tulsa, OKBuilt 1974 · S/N 17702096N202SFCrouch Jeremy · Centerville, OHBuilt 1997 · S/N 007N202SGBassham Diane C · Ames, IAS/N 1015-2006N202SLConstantine Frank L · Flemington, NJBuilt 1969 · S/N 67-16975N202SPColorado State Patrol · Denver, COBuilt 2011 · S/N T18209049N202TLHafen John Mark Jr Trustee · Woodinville, WABuilt 2002 · S/N 22243N202VABrown Gabriel · Navarre, FLBuilt 2003 · S/N SFG026N202VFSidetrack Investments LLC · Flowermound, TXBuilt 2002 · S/N 81195N202VVJeralds Sean K · Prescott, AZBuilt 2012 · S/N 001N202WCHigman David B · Glendora, CABuilt 2006 · S/N 18092CN202WGKitchen Thomas M · Indiana, PABuilt 2000 · S/N G-20233N202WTEngstad Kai · Gig Harbor, WABuilt 2008 · S/N 1847N202WZMeredith Dean J · Boynton Beach, FLBuilt 2000 · S/N 50N20300Congressional Flying Club Inc · Gaithersburg, MDBuilt 1977 · S/N 17702656N2030CSky Bear LLC · Lakewood, CABuilt 2005 · S/N 172S9941N20313Wilde Evan Theodore · Cupertino, CAS/N 17702657N2031CShahen Michael A III · Belleville, ILBuilt 1988 · S/N LAWRENCE0001N2032LBishop Donald J · Live Oak, FLBuilt 1967 · S/N 365N2032MKab Air LLC · Eden Prairie, MNBuilt 1978 · S/N 32-7840077N20339Grant David M · Bellingham, WABuilt 1977 · S/N 17702659N2033CPray Aviation Inc · Augusta, KSBuilt 1959 · S/N TD-203N2033PAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 23-608N2034RPn4 Aviation Holdings LLC · Bishop, CABuilt 1969 · S/N 28-5439N20358Ricky B'S Bodyshop Inc · Berthoud, COBuilt 1977 · S/N 17702661N2035LChris Fuher Flight Instruction LLC DBA · Townsend, MTBuilt 1967 · S/N 368N2036MR&B Helicopters Inc · Calhoun, GABuilt 2000 · S/N 0114N2036TLane James · Raleigh, NCBuilt 1983 · S/N TC1N20375May Matthew J · Weatherford, TXBuilt 1977 · S/N 17702664N2039XMeister James Emmett · New Richmond, WIBuilt 1996 · S/N 27-0224N203AMInternational Jets Inc · Gig Harbor, WABuilt 1979 · S/N 31-7912037N203BWAlexander Katherine · Fishers, INBuilt 1976 · S/N 28R-7635113N203CAStrasbaugh Development Corp · San Luis Obispo, CABuilt 1997 · S/N 4636102N203CCMonarch Air LLC · Dewitt, MIBuilt 1979 · S/N 28-7911110N203CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12501N203DAerotres LLC · Lakeville, MNBuilt 2020 · S/N 2881425N203DMCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1966 · S/N 27-3461N203DSSouth Mountain Aero LLC · Myerstown, PABuilt 2002 · S/N 40.203N203EAEtheredge Mark · Pell City, ALBuilt 2023 · S/N 28020118N203EXAps Asset Management Inc · Mesa, AZS/N 1203N203JCJanzen Brian · Fort Worth, TXBuilt 2003 · S/N 003JCN203JJMidwest Aircraft Sales LLC · Lincoln, NEBuilt 2006 · S/N 40290N203KSMichael Lichtman Inc · Oceanside, CAFirst renewal noticeBuilt 2001 · S/N 172S8856N203LELeading Edge Flight Academy LLC · Bend, ORS/N 11203N203MCMac IV Aeroworks LLC · St Petersburg, FLBuilt 1984 · S/N 5036N203SJCorrado Christopher · Newton, NJS/N 32-40037N20401Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12519N20403Deatherage Edward D · Salina, KSBuilt 1977 · S/N 17702669N2040HAbc Plane LLC · Freeport, TXS/N 18281639
Back to AD 2006-10-21