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.

N629AAAllen Aviation Inc · Aynor, SCBuilt 2023 · S/N T660-182DCN629JPLj Leasing LLC · Cardington, OHBuilt 2002 · S/N 802A-0129N62DBWattum Investments LLC · Kodiak, AKBuilt 1965 · S/N 1578TB7N62DMVision Air LLC · Jacksonville, FLBuilt 2019 · S/N 100-0280N62HQGreen And White Air LLC · Kalamazoo, MIBuilt 1997 · S/N FL-156N62LHKavalair LLC Series F · Marion, MTBuilt 1968 · S/N 97N62LMBroadway Air LLC · Huntsville, ALS/N 67N62LTLima Tango LLC · Mariposa, CABuilt 2001 · S/N 4697027N62SALta Group Holdings LLC · Amarillo, TXBuilt 1997 · S/N LJ-1472N62VDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-74N630LLCroom Aviation LLC · Port Saint Joe, FLBuilt 1994 · S/N T45-006DCN630MAMeyers Air Service LLC · Superior, NEBuilt 2014 · S/N 502B-2963N631BLBancfirst · Oklahoma City, OKBuilt 2005 · S/N 631N632CBIou Aviation Of Montana LLC · Sheridan, WYBuilt 1983 · S/N 31T8166066N633ARTwin Otter Support Services LLC · Las Vegas, NVBuilt 1979 · S/N 633N634BTurbo Air Charter LLC · Boise, IDBuilt 1974 · S/N BC-19N63593Rbr Development LLC · West Plains, MOBuilt 1979 · S/N BB552N635BDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N BC-49N636BDavid Aviation Inc DBA · Brandon, MSBuilt 1978 · S/N BC-61N636KTRustair Inc · Anchorage, AKS/N 451N636QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 2005 · S/N 636N636TAToth Financial Advisory Corp · Leesburg, VABuilt 2002 · S/N BB-1792N637LAMaxwell Flying Service Inc · Benoit, MSBuilt 2001 · S/N 502B-0637N637PCAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 627N637PHCapital Holdings 137 LLC · Tavernier, FLBuilt 2005 · S/N 637N638TWRedline Ag LLC · Mount Vernon, MOBuilt 2008 · S/N 502B-2638N63AWAmerican Ag Aviation Inc · Five Points, CABuilt 1998 · S/N 802A-0063N63HCPort Royal Aviation LLC · Pensacola, FLBuilt 2012 · S/N 100-0063N63TPHot Air LLC · Cambridge, MABuilt 1997 · S/N 128N63VAFairey Ltd · Grand Junction, COBuilt 1955 · S/N 850N640Teufel Holly Farms Inc · Portland, ORBuilt 1944 · S/N 1201N640DFWhy Not LLC · Montezuma, KSBuilt 1992 · S/N LJ-1312N640MYManatee Jet Club LLC · Bradenton, FLBuilt 2005 · S/N 640N640RJMidwest Executive LLC · Reno, NVBuilt 1985 · S/N LJ-1106N642Snow Goose Aviation LLC · Anchorage, AKBuilt 1968 · S/N 1204N642PCAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 642N643EAAir Adventures Corp · Charleston, SCBuilt 2001 · S/N LJ-1643N643PCRegistered aircraftBuilt 2005 · S/N 643N6449BRegistered aircraftBuilt 2009 · S/N LJ-1949N644JCBic Aviation LLC · Fort Smith, ARS/N LJ-698N644SDSierra Delta LLC · Lititz, PABuilt 2005 · S/N 644N645PCValiair Limited Co Trustee · Casper, WYBuilt 2005 · S/N 645N645SBN645 Shares LLC · Liberal, KSBuilt 1984 · S/N 425-0217N647LACsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 502B-2647N647MCRegistration Pending · Dickinson, TXRegistration pendingBuilt 1967 · S/N 087N648DDDashdale Aviation LLC · Fort Dodge, IABuilt 1999 · S/N BB-1683N648LALane Aviation Inc · Rosenberg, TXBuilt 2002 · S/N 502B-0649N649PBoutique Air Inc · Dallas, TXBuilt 2005 · S/N 649N64CDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-32N64DQLongwood Flying Service Inc · Hollandale, MSBuilt 2012 · S/N T34-391
Back to AD 2002-23-13