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.

N527LC527 Lima Charlie LLC · Fresno, TXBuilt 2023 · S/N 100-0330N527PBDavidson Investments LLC · Oklahoma City, OKBuilt 2003 · S/N 527N527PKAir Care Leasing LLC · Lamar, COBuilt 1998 · S/N 402A-1067N528AGAh Aero Services LLC · Heber City, UTS/N 100-0086N528CHWord Jon D · Albuquerque, NMBuilt 1980 · S/N 31T-8020049N528NRMinnesota Department Of Natural Resources · Grand Rapids, MNBuilt 2022 · S/N 100-0315N528PMIrg Aero LLC · El Paso, TXBuilt 2005 · S/N 653N528TGNorthward Bound LLC · Anchorage, AKBuilt 2018 · S/N 100-0238N5297FTri Rotor Spray & Chemical · Ulysses, KSBuilt 2009 · S/N T34-307N5298FBarnett Air LLC · Nezperce, IDBuilt 2009 · S/N T34-313N5298HCrop Dusters LLC · Maurice, IABuilt 2009 · S/N T34-312N529ET700 Ex LLC · Bend, ORBuilt 2012 · S/N EVO-0036N529NRMinnesota Department Of Natural Resources · Grand Rapids, MNBuilt 2015 · S/N 100-0165N529PMCarolina Express LLC · Fairmont, MNS/N 46-97029N5301WTurrell Flying Service Inc · Turrell, ARBuilt 2009 · S/N T34-308N5306BWorsham Farms Flying Service Inc · Camilla, GABuilt 2010 · S/N T34-332N5308SCrop Dusters LLC · Maurice, IABuilt 2010 · S/N T34-326DCN530HPCreek Canyon Aviation LLC · Phoenix, AZBuilt 2001 · S/N 4697101N530WCLaboratory Corporation Of America Holdings · Burlington, NCBuilt 2003 · S/N 530N5320NSaunders Aviation LLC · Lewes, DEBuilt 2003 · S/N 4697153N5322DBlack Phoenix Photography LLC · Morgan Hill, CABuilt 2001 · S/N 4697074N5322MFlight Club LLC · Erie, PABuilt 2000 · S/N 4697021N532AWCsi Aviation Inc · Killeen, TXBuilt 1991 · S/N FA-218N532BAAslesen Leasin LLC · Halstad, MNBuilt 2008 · S/N 402A-1200N532MCAlpha Ag Air LLC · Little River, KSBuilt 2005 · S/N 502B-2594N53369Poor Boy Aero LLC · Seminole, TXBuilt 2001 · S/N 4697088N5339G5339g LLC · Vero Beach, FLFirst renewal noticeBuilt 2001 · S/N 4697095N533GGClf Houston Travel LLC · Houston, TXBuilt 1998 · S/N LJ-1533N533PCJc Air Montana LLC · Missoula, MTBuilt 2015 · S/N 100-0159N534PWCrop Dusters LLC · Maurice, IABuilt 2021 · S/N 510-102N53516Flight Group LLC · Bend, ORBuilt 2002 · S/N 4697132N5353VMidwest Ventures LLC · Wichita, KSBuilt 2002 · S/N 4697141N5355SJohn Galt Industries LLC · Charlevoix, MIBuilt 2002 · S/N 4697136N535BBFlying Bar B LLC · Sandy, UTBuilt 2004 · S/N 596N535MKCapital Holdings 205 LLC · Northampton, PABuilt 2003 · S/N 535N535PNDavis Aviation Inc DBA · Brandon, MSS/N FA-152N537ARAvro Ltd · Las Vegas, NVBuilt 1977 · S/N 537N537JFRad Aviation II LLC · Baton Rouge, LABuilt 2004 · S/N 537N538BHRegistration Pending · Stone Harbor, NJRegistration pendingBuilt 2005 · S/N 626N53993United States Government · Fort Belvoir, VAFirst renewal noticeBuilt 1985 · S/N 104N53ARGuardian Flight LLC · Lewisville, TXBuilt 1998 · S/N BB-1629N53BAIvester Drywall & Painting Inc · Salisbury, NCBuilt 1979 · S/N BB-426N53GA52 Whiskey LLC · Elkhart, INBuilt 1985 · S/N BB-1201N53KADesert Mountain Air LLC · Kalispell, MTBuilt 1981 · S/N BB-880N53KBHiers Properties Of Delaware LLC · Chattanooga, TNBuilt 2005 · S/N 4697231N53TJNion LLC · New Century, KSBuilt 1989 · S/N LJ-1209N53UPhenphilo3 LLC · Wilmington, DEBuilt 2000 · S/N 208B0855N540MAN540ma LLC · Metairie, LABuilt 2001 · S/N BB-1765N54199Key Aviation Group LLC · Meridian, MSBuilt 2003 · S/N 4697164N541PBUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 541
Back to AD 2002-23-13