OpenAirDocs.org
AD 2002-23-13

Registered aircraft · 3,462

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-13')
    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-13')
  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.

N278SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N LJ-1011N279KQLmg-Rba LLC · Georgetown, TXBuilt 2019 · S/N 100-0279N27BFJab Air LLC · Ponte Vedra Beach, FLBuilt 1981 · S/N 31T-8104038N27BNTravelaire Service Inc · Wilmington, DES/N BB-1268N27MGAvion Capital Corp · Anchorage, AKBuilt 1997 · S/N 208B0650N27NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1987 · S/N 008N280SPSan Pablito Ranch Aviation LLC · Hebbronville, TXBuilt 2000 · S/N BB-1740N280TRAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 1988 · S/N 760344N281AJK & L Rentals LLC · Henderson, NVBuilt 2016 · S/N EVO-0077N281DLThisius Flying Service Llp · Wells, MNBuilt 2013 · S/N 402B-1281N281LABoedeker Flying Service East LLC · Childress, TXBuilt 2008 · S/N 402B-1201N282CAKurcon Inc · Poultney, VTBuilt 2011 · S/N EVO-024N282LAProp Ag LLC · Montezuma, KSBuilt 2012 · S/N 602-1215N282PMPlanemasters Ltd · West Chicago, ILBuilt 2002 · S/N 208B0981N283JDDurham Aircraft LLC · Port Aransas, TXBuilt 1991 · S/N FL-69N283PMPlanemasters Ltd · West Chicago, ILBuilt 1999 · S/N 208B0774N283TATommys Flying Service · Sherrill, ARBuilt 2009 · S/N T34-314DCN284MRDale Aviation Inc · Rapid City, SDBuilt 2005 · S/N LJ-1729N284PMArtic Legacy Aviation LLC · Anchorage, AKBuilt 1977 · S/N LJ734N285KCCourt Reporter Assignments Inc · Bullhead City, AZBuilt 2023 · S/N 4698285N285PBBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 585N285RBButler National Inc · New Century, KSBuilt 1999 · S/N FL-264N285XOh Hi Sky LLC · Los Angeles, CABuilt 2010 · S/N EVO-005N286PMPlanemasters Ltd · West Chicago, ILBuilt 1997 · S/N 208B0631N287JJA L S A P Enterprises LLC · Missoula, MTBuilt 2020 · S/N 100-0287N288AFMod-Pac Corp · Portsmouth, NHBuilt 2023 · S/N 2288N288ATN38ry LLC · California, MDBuilt 1987 · S/N FA134N289ATN999mg LLC · California, MDBuilt 1991 · S/N FL-65N289JARiceland Aviation Inc · Jennings, LABuilt 2012 · S/N 502B-2809N289PCTuca 27 LLC · Lewes, DEBuilt 1991 · S/N 546N28ANPa1 208b-0751 LLC · Fort Lauderdale, FLBuilt 1999 · S/N 208B0751N28NRJaars Inc · Waxhaw, NCBuilt 2009 · S/N 100-0024N28VRPajaro 195 LLC · Fort Worth, TXBuilt 1996 · S/N BB-1540N2904GMec Aviation Kodiak LLC · Gainesville, GABuilt 2020 · S/N 100-0290N290BCTraven Ricardo Siro · Georgetown, SCBuilt 2004 · S/N 1092N290CCMonument Aviation LLC · North Chesterfield, VABuilt 1966 · S/N LJ132N290NCMr Boo Properties LLC · Indianapolis, INBuilt 1987 · S/N LJ1158N290PASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1971 · S/N LJ-519N291DFRmb Leasing Inc · Dover, DEBuilt 1998 · S/N LJ-1534N291DLNorthstar Aero Spray Inc · Clara City, MNBuilt 2008 · S/N 402B-1199N292KQNortheast Elite Aviation LLC · Oakland, MEBuilt 2013 · S/N 100-0092N292PSteelman Aviation Inc · Las Vegas, NVBuilt 2005 · S/N 630N293KDKodiak Special LLC · Huntsville, ALBuilt 2021 · S/N 100-0293N294DRValiair Lc Trustee · Casper, WYBuilt 2004 · S/N 4697184N294LARoma Air Corp · Belle Glade, FLBuilt 2000 · S/N 802A-0094N294TTUncommon Solutions LLC · Hollis, NHBuilt 1984 · S/N LJ1098N294ZPCumulus Aviation Inc Trustee · Wilmington, DEBuilt 1980 · S/N 31T-8020063N295DCHibiscus26 Inc Trustee · Wilmington, DEBuilt 2000 · S/N BB-1709N297FAWalhalla Ag Service LLC · Walhalla, NDBuilt 2014 · S/N 502B-2973N297KDAir Sansone LLC · New Castle, DEBuilt 2021 · S/N 100-0297
Back to AD 2002-23-13