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.

N242JMLitsky Steven H · University Place, WABuilt 1994 · S/N 0677N242JWAviation Leasing Co LLC · Ooltewah, TNBuilt 2019 · S/N 172S12279N242KFTio Pedro P · Miami, FLBuilt 2002 · S/N 3257277N242KMPlane Care Inc · Weston, FLBuilt 1977 · S/N 32-7740111N242LHMatthews Micheal S · Reno, NVBuilt 1994 · S/N 0673N242MEMike Echo Ventures LLC · Coral Gables, FLBuilt 2000 · S/N 20608112N242MGHelo 1 LLC · Anchorage, AKBuilt 2006 · S/N 11134N242MPWestwood Dave · Red Lodge, MTBuilt 1994 · S/N 0660N242MZBechara Nizar E · Columbia, MDBuilt 1999 · S/N 0732N242NPBa Flight Experience LLC · Margate, FLBuilt 1976 · S/N 28-7790137N242PHoeme Eric L · Leoti, KSBuilt 1967 · S/N 28-10998N242RBContinental Aerospace Technologies Inc · Mobile, ALBuilt 2011 · S/N 172S11131N242RKBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 31-7512025N242RSPape Brandon M · Mc Gregor, TXBuilt 1997 · S/N 2054N242RVSearle Ronald Q · Franktown, COBuilt 2025 · S/N 41676N242SBMartin Thomas R · Roseville, MNBuilt 1989 · S/N 001N242SP242sp LLC · Blaine, MNBuilt 1999 · S/N 172S8226N242TC182 Flight Corp · Bronx, NYBuilt 2005 · S/N T20608530N242TWTw Airplane LLC · San Antonio, TXBuilt 2005 · S/N 172S9896N242USilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608242N242YAerospace Development Group Inc · Trinity, FLBuilt 2004 · S/N 40.404N24301Pacific Coast Cycle Corp · Kings Beach, CABuilt 1999 · S/N T20608139N2430YBuckman Arnold H Trustee · Spring Valley, ILBuilt 1985 · S/N 32R-8513002N24318Milo Technologies LLC · Woodstock, GABuilt 2001 · S/N 17280994N2431GGulf Coast Helicopters Inc · Pearland, TXBuilt 2000 · S/N 18280681N2431QWade Consulting LLC · Aviston, ILBuilt 2000 · S/N 18280684N2431SDavis Girls LLC · San Jose, CABuilt 1979 · S/N R18201340N24334Sorbi Aviation Inc · El Cajon, CABuilt 2000 · S/N 17280887N24337Dunn Craig M · Sarasota, FLBuilt 2000 · S/N 18280713N2433EElco Electric · Bangor, MEBuilt 2000 · S/N 20608136N2433SN2433s LLC · Manassas, VABuilt 2000 · S/N 17280872N2433UEddleman David Baggett · Mclean, VABuilt 2001 · S/N T18208006N24342Loma Aviation LLC · San Diego, CABuilt 1973 · S/N 287305419N2434MSky'S The Limit Flying Club Inc · Findlay, OHBuilt 1977 · S/N 28-7890251N2434YRegistration Pending · Cedar Falls, IARegistration pendingBuilt 2000 · S/N 20608078N24350Aero Equities LLC · Ventura, CABuilt 2006 · S/N 172S10144N2435CAzure Skies LLC · Bloomington, INBuilt 1999 · S/N 18280644N2435MBrolan Aviation LLC · Kansas City, MOBuilt 1977 · S/N 28-7890253N2436MVenture Aviation Inc · Arlington, MABuilt 1977 · S/N 28R-7837089N2436NThunderbird Aviation · Bloomington, MNBuilt 2000 · S/N 17280842N2436WThunderbird Aviation · Bloomington, MNFirst renewal noticeBuilt 2000 · S/N 17280841N24372Curns James R · New London, WIBuilt 1970 · S/N 28-5665N24376C R Transport Inc · Wilmington, DEBuilt 2000 · S/N 18280704N2437MRock Full Gospel Church · Parkersburg, WVBuilt 1979 · S/N 27-7954058N24389Way Of The Lord LLC · London, KYBuilt 2000 · S/N 18280708N2438ERainier Flight Service LLC · Renton, WABuilt 2000 · S/N 17280878N2438RSpeed Hunter Aviation LLC · Franklin, OHBuilt 1969 · S/N 28-5622N2438SMid-Island Air Service Inc · Ronkonkoma, NYFirst renewal noticeBuilt 2000 · S/N 17280875N2439BVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N 18280955N2439C206 Aircraft Leasing Co Inc · Marathon, FLBuilt 2000 · S/N 20608100
Back to AD 2006-10-21