AD 2002-23-11

Registered aircraft · 1,985

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:2002-23-11')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-11')
  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.

N1459General Atomics Aeronautical Systems Inc · San Diego, CABuilt 2009 · S/N FL-667N146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1982 · S/N BB1046N148AATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N FM-12N148SKBering Air Inc · Nome, AKBuilt 1995 · S/N UE-148N149CCCianbro Corp · Baltimore, MDS/N FA-145N149SFAlpine Aviation Inc · Provo, UTBuilt 1991 · S/N UC-149N14HHDelaware Professional Aviation LLC · Dalton, GABuilt 1988 · S/N BB-1286N14NGFirst Avenue Management LLC · Savannah, GABuilt 1987 · S/N BB-1276N150CNKing Air Investments LLC · Ferriday, LABuilt 1981 · S/N LA-138N150GXWest Penn Aviation LLC · Midland, TXBuilt 2008 · S/N FL592N150KJAlpine Aviation Inc · Provo, UTBuilt 1991 · S/N UC-150N150RFR & F Wings III LLC · Liverpool, NYBuilt 2015 · S/N FL-1023N150RLTigress Air III LLC · California, MDBuilt 1982 · S/N BL-50N150YDSfh Inc DBA · Fargo, NDBuilt 1997 · S/N BB-1561N151ELCarolina Turbine Sales Inc · Raleigh, NCBuilt 1978 · S/N BB-371N151QDepartment Of Homeland Security · Washington, DCBuilt 2015 · S/N FM-59N151WTKo Aviation LLC · Wilmington, DEBuilt 1983 · S/N BB-1151N152WLHeart One LLC · Little Rock, ARBuilt 1977 · S/N BB-260N153GAAlpine Aviation Inc · Provo, UTBuilt 1985 · S/N UB-34N153GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-153N154GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-25N154GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-154N154KFRegistered aircraftBuilt 2016 · S/N FL-1054N155AVTeton Leasing LLC · Pocatello, IDBuilt 1985 · S/N BB-1216N155BBRegistration Pending · Greer, SCRegistration pendingBuilt 1997 · S/N BB-1554N155CJUe-55 LLC · Helena, MTS/N UE-55N1560Davis Aviation Inc · Brandon, MSS/N BC-09N1568GUas Transervices Inc · Boca Raton, FLS/N UC-58N156LAFresno Beverage Co Inc DBA · Fresno, CABuilt 2018 · S/N FL-1153N156TMWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N FL-518N157CKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N UE157N159SFSuburban Air Freight Inc · Omaha, NEBuilt 1991 · S/N UC-159N15GABering Air Inc · Nome, AKS/N UE37N15KALighthouse Air LLC · Hobe Sound, FLBuilt 1979 · S/N BB-457N15WCDakota Aviation LLC · Santa Ana, CABuilt 2016 · S/N FL-1063N160RWRitch Air LLC · Visalia, CABuilt 1998 · S/N FL-226N160SFTriumph Aviation LLC · Gaylord, MIBuilt 1975 · S/N BB-32N160SMAviation Star S LLC · Beaumont, TXBuilt 1998 · S/N FL-215N161VDepartment Of Homeland Security · Washington, DCBuilt 2011 · S/N FM-52N162GDepartment Of Homeland Security · Washington, DCBuilt 2017 · S/N FM-72N162GCUnited States Department Of Interior · Boise, IDBuilt 1985 · S/N BB-1238N162QMartin Foundry Service Inc · Glencoe, ALBuilt 1982 · S/N BB-1104N163BALbk Air LLC · Newark, DEBuilt 1984 · S/N FA-18N1655MMichigan Aeronautics Commission · Lansing, MIBuilt 1999 · S/N BB-1655N165TGAmj Aviation LLC · Oneida, TNBuilt 1997 · S/N FL-165N165YVAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-165N166BASmith Joshua B · Kenai, AKBuilt 1988 · S/N FA-147N166CLKa Partners LLC · Thomson, GABuilt 2000 · S/N FL-298N166SAClear Skies Ltd · Cincinnati, OHBuilt 1988 · S/N FA-166N167CDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N FM-86
Back to AD 2002-23-11