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.

N458VKValkyrie Aero LLC · Mesa, AZBuilt 1995 · S/N 458N45FLRegistered aircraftBuilt 1993 · S/N NC-45N460EMEaglemed LLC · Wichita, KSBuilt 2000 · S/N LJ-1593N4615CNorth American Flight Services Inc · Ballston Spa, NYBuilt 1991 · S/N LJ-1273N461BBFlite Level Zero LLC · Stanfield, ORBuilt 2000 · S/N 4697016N461JADesign Builds LLC · West Point, VABuilt 2003 · S/N 4697168N461RGNew Pig Corp · Tipton, PABuilt 2012 · S/N LJ-2040N461VFFlight International Corp Trustee · Flagstaff, AZS/N 46-8408049N463RSRts Aviation LLC · Atlanta, GABuilt 1987 · S/N LJ-1143N465MENorthlake Capital LLC · Ridgeland, MSBuilt 2005 · S/N 4697233N465SKAv8 LLC · Paso Robles, CABuilt 2000 · S/N 4697013N465SPSamaritans Purse · Boone, NCBuilt 2008 · S/N 100-0006N465TASouthwest Aviation Specialties LLC · Tulsa, OKS/N LJ630N465TPMountain Holding Inc · Cody, WYBuilt 2005 · S/N 4697204N466BCBc Air LLC · Moses Lake, WABuilt 2014 · S/N 100-0114N466SPSamaritans Purse · Boone, NCS/N 100-0015N468SPPacific Mission Aviation · Hagatna, GUBuilt 1998 · S/N BB1639N468ZBBrown Helicopter Inc · Pensacola, FLBuilt 1988 · S/N 760345N469BUnited States Construction Corporation · Pompano Beach, FLBuilt 1978 · S/N LJ-803N469KSB&L Aviation LLC · Mesa, AZBuilt 2015 · S/N EVO-0058N469SBK-Town Aviation LLC · Louisville, TNBuilt 2003 · S/N 4697162N469TSDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1968 · S/N 149N46AEBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N LJ-1582N46CECentury Equipment Company Inc · Salt Lake City, UTBuilt 1994 · S/N BB1492N46MEFishlover'S Management LLC · Chandler, AZBuilt 2005 · S/N 4697207N46PLAvcorp Leasing Inc Trustee · Wilmington, DEBuilt 2001 · S/N 4697054N470KAKerola Aviation Inc · Masury, OHBuilt 1993 · S/N FL-109N470MMSfc Global Supply Chain Inc · Marshall, MNBuilt 2000 · S/N UE-394N471VYBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N LJ-1957N473QHBrown Helicopter Inc · Pensacola, FLBuilt 1986 · S/N 760331N473TWNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 2001 · S/N 208B0894N474LCAlpine Aviation Inc · Provo, UTBuilt 1993 · S/N UE-74N474VKValkyrie Aero LLC · Mesa, AZBuilt 1995 · S/N 474N4757SBombay Glass Corp · Depoe Bay, ORS/N 4697006N475LAPost Rock Aviation Inc · Lincoln, KSBuilt 2006 · S/N 402B-1175N476XPMatonti James Robert · BanglamungRegistration ineffective or invalidBuilt 1968 · S/N 2040N477HCParish Air Inc · San Diego, CABuilt 2003 · S/N 4697171N477JMBehrens Aircraft Leasing LLC · Waukesha, WIBuilt 1979 · S/N BB-538N477MAircraft Unlimited Inc · Pierre, SDBuilt 1987 · S/N LJ-1154N477XPParaclete Aviation LLC · Raeford, NCBuilt 2000 · S/N 208B0833N478CRAlg Aircraft LLC · Delano, CABuilt 1997 · S/N LJ-1474N478VKValkyrie Aero LLC · Mesa, AZBuilt 1996 · S/N 478N479AKSafeco Leasing LLC · Port Alsworth, AKBuilt 1970 · S/N B-96N479BCm Aviation LLC · Corsicana, TXBuilt 2002 · S/N FL-338N479SAEarthcom Inc · Williamston, MIBuilt 1967 · S/N LJ215N479VATactical Aviation Inc · Wilmington, DEBuilt 1998 · S/N BB1601N47CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0033N481ZGalazy Lift II LLC · New York, NYBuilt 1973 · S/N LW-52N482ATAerinova Aerial LLC · Mattoon, ILBuilt 2013 · S/N 402B-1280N482GDelta Kilo Mike LLC · Rayville, LABuilt 2022 · S/N 100-0316
Back to AD 2002-23-13