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.

N506MVFirecracker Air LLC · Missoula, MTBuilt 1999 · S/N FL-261N5075LAslesen Leasin LLC · Halstad, MNBuilt 1998 · S/N 502B-0480N5075PPeterson Tony D · Humboldt, IABuilt 1997 · S/N 502B-0439N50761Arthur Aviation LLC · Arthur, NDBuilt 1998 · S/N 402A-1065N507GFBallard Aviation Inc · Newton, KSBuilt 2001 · S/N BB-1778N507HBBruton Aerial Spraying Inc · Garden City, TXBuilt 2012 · S/N 502B-2810N507RCDodson International Parts Inc · Rantoul, KSBuilt 2003 · S/N 507N5085QScl Aviators · Wilmington, DEBuilt 1997 · S/N 402B-1047N50877Arrow Aviation Inc · Broken Bow, NEBuilt 1997 · S/N 502B-0472N508HBKansas Farm & Ranch Inc · Seneca, KSBuilt 2012 · S/N 502B-2816N508HMDt Pralle Enterprise Inc · Hampton, IABuilt 1994 · S/N 502B-0268N508RJBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 20800315N508SKMagnolia Logistics Of Ms LLC · Flowood, MSBuilt 1985 · S/N FA-78N5091HLake Air Service LLC · Jennings, LABuilt 1997 · S/N 602-0444N5091NFarm Air Flying Service LLC · Sacramento, CABuilt 1997 · S/N 502B-0475N50927Prairie Ag Service LLC · Des Arc, ARBuilt 1997 · S/N 402A-1041N5092GSteinke Matthew · Gibson, IABuilt 1998 · S/N 502B-0515N5094HWoodley Aerial Leasing LLC · Walnut, ILBuilt 1998 · S/N 802A-0067N509GFGibson Flying Service Inc · Marianna, ARBuilt 2020 · S/N 502B-3228N509JJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 4698223N50BRBartholow Rental Company Inc · Wylie, TXBuilt 2001 · S/N LJ-1632N50FKFirecracker Inc · Eugene, ORBuilt 1984 · S/N 006N50GGN50gg Leasing LLC · Ponca City, OKBuilt 2000 · S/N BB-1728N50KAKenmore Air Harbor LLC · Kenmore, WABuilt 1956 · S/N 221N50KQFaulconer Construction Company Inc · Charlottesville, VABuilt 2018 · S/N 100-0250N50NABv Transportation LLC · Portland, ORBuilt 1995 · S/N BB1504N5100DTall Towers Aviation Inc · Page, NDBuilt 1997 · S/N 502B0412N51019Lohmann Jack R · Frisco, COBuilt 2000 · S/N 4697008N5101CThrush Aircraft LLC · Albany, GABuilt 2020 · S/N T34-502N5102AThrush Aircraft LLC · Albany, GABuilt 2020 · S/N T34-503N5109HAlexander Ag Flying Service Inc · Walnut Grove, CABuilt 1997 · S/N 502B-0460N510GSAmdel Holding LLC · Houston, TXBuilt 2001 · S/N BB-1746N510LFRcl Farms Leasing LLC · Wilmington, DEBuilt 2023 · S/N 510-122N5110SChoctaw Flying Service Inc · Inverness, MSBuilt 1997 · S/N 402A-1043N5110ZPonderosa Airtankers LLC · Safford, AZBuilt 1998 · S/N 802A-0060N5111PDe La Vega Artemio · Dallas, TXBuilt 1986 · S/N LJ-1136N5119GTri-Air Farms LLC · Mamou, LABuilt 1997 · S/N 502B-0474N511HBArthur Aviation LLC · Arthur, NDBuilt 2011 · S/N 502B-2754N511KVDelta Fox LLC · Woodland, CABuilt 1995 · S/N LJ1422N511LACavanaugh Flying Serivce Inc · Minden, NEBuilt 2007 · S/N 502B-2611N511TAAir Med Services LLC · Lafayette, LABuilt 1999 · S/N BB-1660N5120EC & L Holzwarth Inc · Virden, ILBuilt 1998 · S/N 402B-1052N5123UR & D Leasing Inc · Lemoore, CABuilt 1997 · S/N 802A-0053N5124PIndependent Dusting Service Inc · El Campo, TXBuilt 1998 · S/N 402A-1051N5127BFarmair LLC · Lagrange, INBuilt 1997 · S/N 502B-0437N5128NBasin Aviation Inc · Rio Oso, CABuilt 1998 · S/N 402A-1054N512ARTwin Otter International Ltd · Las Vegas, NVBuilt 1967 · S/N 59N512MPFarm Air Flying Service LLC · Sacramento, CABuilt 2014 · S/N 502B-2948N512RMFerry Lars C · Phoenix, AZBuilt 2013 · S/N 043N513HBKansas Farm & Ranch Inc · Seneca, KSBuilt 2013 · S/N 502B-2901
Back to AD 2002-23-13