AD 2002-19-03

Registered aircraft · 12,723

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-19-03')
    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-19-03')
  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.

N115DSOverly Christopher Daniel · Williamsport, OHBuilt 2000 · S/N 2028N115DWMav LLC · Erie, COBuilt 2024 · S/N 4636848N115FMCary Steven B · Brookshire, TXS/N 160N115GTWahl John H · Rockwell City, IAS/N 20042N115HPCam Aviation LLC · Valparaiso, INBuilt 1998 · S/N 3246115N115JDC R Aviation Inc · Miami, FLS/N 27-7405395N115JWFeric Drazen · Mesa, AZBuilt 1976 · S/N 14081N115KTMulva Jonathan · De Pere, WIBuilt 2002 · S/N 20044N115MDSpecial Orthogonal Group LLC · Dover, DEBuilt 2001 · S/N 20039N115PFHigh Tech Metals Inc · Harrisburg, PABuilt 1998 · S/N 18280224N115PSAg Farmacy Applications LLC · Erie, ILBuilt 2007 · S/N 12047N115RHRegional Helicopters LLC · Anchorage, AKBuilt 2013 · S/N 13470N115SJWolf Richard · Yerington, NVBuilt 1994 · S/N 14614N115SZThree Greens LLC · San Jose, CABuilt 2000 · S/N 20036N115TPCavu Enterprises · Edgerton, WIBuilt 2013 · S/N 114N115VSSei Vincent J · Albuquerque, NMBuilt 2005 · S/N 115N1162UHamel Raymond F Jr · Wellesley, MABuilt 2007 · S/N 18281984N1164JTyson Bradley · Sherrills Ford, NCBuilt 2023 · S/N 18283240N1165XLechtenberg Lance · El Dorado, KSBuilt 1975 · S/N 32-7540150N1165ZRegistration Pending · Las Cruces, NMRegistration pendingBuilt 1965 · S/N 1555-198N116CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283012N116DRegistration Pending · Reese, MIRegistration pendingBuilt 2022 · S/N 18283203N116GRegistration Pending · Sheridan, WYRegistration pendingBuilt 1995 · S/N 23019CN116GWMajestic Airlines Inc DBA · Lynden, WABuilt 1970 · S/N 31-662N116MFWeber Donald E · Saint David, AZS/N 27-3522N116RCMiesch Gary D · Gowen, MIBuilt 1976 · S/N 14061N116SB114b Holding Inc Trustee · Wilmington, DEBuilt 2000 · S/N 14678N116SLXcel Aviation LLC · Eagle, IDBuilt 2003 · S/N 18281242N116SMArchie Aero LLC · Beaverton, ORBuilt 2005 · S/N T18208426N116VGBruns Phillip T · Shiro, TXBuilt 1998 · S/N 18280346N116WBDunch David J Trustee · Poland, OHBuilt 1998 · S/N 18280170N116ZXVranjes Peter · Johnstown, COBuilt 1997 · S/N 18280042N1171JNational Test Pilot School · Mojave, CABuilt 2007 · S/N 18281985N1174CGeorgia Forestry Commission · Macon, GABuilt 2007 · S/N 18281905N1176RBas Part Sales LLC · Greeley, COBuilt 2005 · S/N 18281688N1176TP C O Leasing Inc · Dobbin, TXBuilt 2005 · S/N 18281587N1176ZAirborne Support Inc · Bourg, LABuilt 1965 · S/N 500-B-1549-196N1177AN1177a LLC · Lewes, DEBuilt 1977 · S/N 32R-7780430N117BDHall Alan Ray · Willow Park, TXBuilt 2017 · S/N 18283024N117BMManeck Aviation LLC · Columbus, GABuilt 1997 · S/N 46-36078N117CSSam Airlines LLC · Wilmington, DEBuilt 1996 · S/N 32-46024N117GHAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N 3257217N117HREmax LLC · Perry, GAS/N 287N117JCHillsboro Flying Club · Hillsboro, ORBuilt 1980 · S/N 32-8006032N117KRFox Planes LLC · Sterling Heights, MIBuilt 1997 · S/N 4636088N117LELeading Edge Aviation Inc · Bend, ORFirst renewal noticeBuilt 2007 · S/N 11714N117MCParish Of East Baton Rouge · Baton Rouge, LABuilt 1988 · S/N 2178N117SEHalsell Jason · Wolfforth, TXBuilt 2004 · S/N 3255017N117TDGiffin Craig D · Windermere, FLBuilt 1990 · S/N 27-0074N117WVRedline Onsite Services LLC · Opelousas, LABuilt 1990 · S/N 3115
Back to AD 2002-19-03