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.

N169GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-169N169RWJorgensen Air Service LLC · Puyallup, WABuilt 1982 · S/N BB-1030N16CMBartholow Rental Co Inc · Wylie, TXBuilt 1997 · S/N BB-1580N16HGBear Air LLC · Mount Vernon, INBuilt 1999 · S/N BB-1647N16WGSomers-Lawson Land & Cattle LLC · Midland, TXS/N LA-226N170GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-170N170JCWlgb200 LLC · Reno, NVBuilt 1998 · S/N BB-1606N170RLN170rl LLC · California, MDBuilt 1983 · S/N BT28N171CJBering Air Inc · Nome, AKBuilt 1993 · S/N UE-71N172GAAlpine Aviation Inc · Provo, UTS/N UB-11N173BDept Of Homeland Security · Washington, DCBuilt 2019 · S/N FM-84N173KSCentralav LLC · Lake Worth, FLS/N FA-82N173MLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N FL-1151N173TX173 Tango X-Ray LLC · Houston, TXBuilt 1982 · S/N BB-1028N174JBAes Aviation LLC · Tuskegee, ALBuilt 1992 · S/N BB-1429N175PLTp Air LLC · Laredo, TXBuilt 2019 · S/N FL-1187N175SAGeneral Atomics · San Diego, CABuilt 1976 · S/N BB-183N176LABallard Aviation Inc · Newton, KSBuilt 1983 · S/N LA-210N176MRegent Trust Corp Trustee · Wichita, KSBuilt 1982 · S/N BB-1029N176YVHill Air Executive Inc · Fort Pierce, FLBuilt 1995 · S/N UE-176N177CNRca Aviation 2 LLC · Tempe, AZBuilt 1984 · S/N BB-1191N177GATippen Steel Services Inc · Boyd, TXBuilt 1997 · S/N FL-160N177LACabeza De Vaca Holdings LLC · Carrollton, TXBuilt 1985 · S/N BB1203N17812Best Aircraft Deals LLC · Salt Lake City, UTS/N BB236N178LAPonca International LLC · Bentonville, ARBuilt 1982 · S/N LA-178N178YVAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-178N179WBShaken Aviation LLC · Madison, ALBuilt 2011 · S/N FL-773N17CELdc Air LLC · Rochester, NYS/N FL120N17EHSystem Packaging Co Inc · Bell, CABuilt 1986 · S/N BB1257N17GGJ Aviation LLC · Boca Raton, FLBuilt 2004 · S/N FL-419N17VAOptimal Aviation Services LLC · Visalia, CABuilt 1980 · S/N BB-670N17WCHm Aviation Holdings LLC · Fort Pierce, FLBuilt 1997 · S/N FL-168N17WGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N BB-1602N17YLYowell Legacy Aviation LLC · Killeen, TXBuilt 1990 · S/N FL-1N182CASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N LA-121N18471Chase Air LLC · Montgomery, ALBuilt 1981 · S/N LA-161N184DNorth Country Holdings LLC · Moses Lake, WABuilt 1987 · S/N FA-132N184TXZms Aviation LLC · Wilmington, DEBuilt 1985 · S/N BB-1241N184UXAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-184N1857F56 Express LLC · Willmar, MNBuilt 1981 · S/N LA-167N185MVSouthwest Aviation Inc Div · Marshall, MNBuilt 1982 · S/N BB-1034N1867State Of Alaska · Anchorage, AKS/N FL-815N187MRJcs Air LLC · Auburn, ALS/N BB-873N187VDepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N FL-679N188ALAlm Holdings Delaware 3 LLC · Wilmington, DES/N BB-111N188KAErostar LLC · Wilmington, NCBuilt 2024 · S/N FL-1333N189ALAlm Holdings Delaware 4 LLC · Wilmington, DES/N BL32N189APRegistered aircraftBuilt 1975 · S/N BB-59N189MDCae III Ltd · Wilmington, DEBuilt 2014 · S/N FL-931N18AFN220pb LLC · Mesa, AZBuilt 1994 · S/N BB-1497
Back to AD 2002-23-11