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.

N717PAPa1 208b-0804 LLC · Fort Lauderdale, FLBuilt 2000 · S/N 208B0804N718FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0448N718KWWarren Transportation LLC · Dallas, TXBuilt 1968 · S/N 120N7198YDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1972 · S/N LU-02N7199DDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1972 · S/N LU-06N7199HDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1971 · S/N LU-07N7199LDynamic Avlease Inc · Bridgewater, VABuilt 1971 · S/N LU-09N7199SDynamic Avlease Inc · Bridgewater, VABuilt 1972 · S/N LU-11N719BHWilliams Farms LLC · Panhandle, TXBuilt 1979 · S/N BB-564N719FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0450N71KQN71kq Holdings Inc · Middletown, DEBuilt 2012 · S/N 100-0071N71SCWestwind Aircraft Leasing LLC · Phoenix, AZBuilt 2003 · S/N 208B0997N7206EEt Aviation LLC · Alcoa, TNS/N LA-234N720AMKing Eagle II LLC · Grand Blanc, MIBuilt 1999 · S/N BB-1663N720COscar Charlie LLC · California, MDBuilt 1973 · S/N B-171N721MBDgw Enterprises LLC · Edina, MNS/N 91N721RDKing Edward Inc · Cullman, ALBuilt 1980 · S/N BB677N721SRNcs Aviation LLC · Bemidji, MNBuilt 2000 · S/N 181N72213Skyline Aviation Services LLC · Miramar, FLBuilt 1994 · S/N LJ-1450N722FHEmerald Air Services Inc · Homer, AKBuilt 1961 · S/N 429N722FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0454N722PMAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N LJ-1820N722VBCopacetic Air LLC · Rutledge, TNS/N LJ987N723United States Dept Of The Interior · Boise, IDBuilt 2010 · S/N 100-0036N7230HAb Aviation LLC · Johns Island, SCBuilt 1985 · S/N LJ-1113N723ARTwin Otter International Ltd · Las Vegas, NVBuilt 1980 · S/N 723N723FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0456N723SCRegistered aircraftBuilt 1994 · S/N NC-50N724AAAlbright Insurance Holdings Inc · Burlington, NCBuilt 1998 · S/N BB-1632N724BSProgressive Veterinary Transport LLC · Christiansted, VIBuilt 2014 · S/N EVO-0049N724DMBusker Aviation LLC · Detroit Lakes, MNBuilt 1999 · S/N 143N724FHEmerald Air Service Inc · Homer, AKBuilt 1958 · S/N 267N724FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0458N724HFAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 564N724KHCloud Nine Corp · Batesville, INBuilt 1995 · S/N LJ-1426N725FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0460N725LMSimply Living LLC · Fort Myers, FLBuilt 2002 · S/N 20800351N725RABar Environmental Supply Inc · Brentwood, TNBuilt 1980 · S/N BB-725N725VBHay Mountian Aviation LLC · Saint Petersburg, FLBuilt 2017 · S/N EVO-0076N726FXFederal Express Corporation · Memphis, TNS/N 208B0465N726RSSugden Richard · Wilson, WYBuilt 2010 · S/N 100-0043N726SHRegistered aircraftBuilt 2025 · S/N 100-0363N7277FBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N LJ-1837N727CLSug Air LLC · Corpus Christi, TXBuilt 2014 · S/N 502B-2955N727FHEmerald Air Service Inc · Homer, AKBuilt 1958 · S/N 307N727FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0468N727TFBoise Aviation Services LLC · Boise, IDBuilt 2020 · S/N EVO-0075N728DWNela Management Services LLC · Monroe, LABuilt 2004 · S/N LJ-1713N728FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0471N729AAAllen Air 2 LLC · Litchfield, MNBuilt 2025 · S/N 46020078
Back to AD 2002-23-13