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.

N813DGBristow LLC · Lake Charles, LABuilt 2006 · S/N 31032N81400E&D Farms LLC · Wilmington, DEBuilt 1981 · S/N 400-0353N81437Solomon Mark Trustee · Wilmington, DEBuilt 2012 · S/N LJ-2037N8149SIcu.Net Inc · Tulsa, OKBuilt 1993 · S/N NC-35N814BCRegistered aircraftS/N 548N814LCN814 LLC · Dover, DEBuilt 1990 · S/N LJ1247N814RHGrowers Air Service Inc · Woodland, CABuilt 2016 · S/N 502B-3063N814SSHilcorp Equipment LLC · Anchorage, AKBuilt 2014 · S/N 901N8156ZWings Of Dawn LLC · Valley Center, KSBuilt 1993 · S/N LJ-1333N8158XPatterson Frederick W III · American Canyon, CAS/N NC-42N815CFMeridian Air LLC · New Boston, MIBuilt 2006 · S/N 4697242N816BPAls Aviation LLC · Westlake Village, CABuilt 1985 · S/N 480N816BSN811kc LLC · Sunrise, FLBuilt 1992 · S/N BB-1440N816GGGoodwin Bryan · Fort Smith, ARBuilt 2019 · S/N 4697658N817MSCarmarc II LLC · Miami, FLBuilt 2001 · S/N LJ-1629N81820Uas Transervices Inc · Boca Raton, FLBuilt 1987 · S/N U232N818FWPelican Aircraft Inc · Wilmington, DEBuilt 1991 · S/N BB-1394N818JCVogel Engineers Inc · Walnut, CABuilt 2025 · S/N K098N818SJEdwards William J · Mccall, IDBuilt 2009 · S/N EVO-011N819EEVaquero Skies LLC · El Paso, TXBuilt 1997 · S/N FL-187N819MHC&W Logistics LLC · Garden City, KSFirst renewal noticeBuilt 1977 · S/N LJ-735N819SWWho Dey LLC · Savannah, GABuilt 1981 · S/N 31T-8104059N81BLScott Manufacturing LLC · Henderson, KYBuilt 2003 · S/N 4697160N81ETRussell Timothy Lee Jr · Saint Petersburg, FLBuilt 1998 · S/N BB1625N81KQBlue Sky Air Services LLC · Wilmington, DEBuilt 2012 · S/N 100-0081N81SUMedary Aviation LLC · Brookings, SDBuilt 1989 · S/N LJ-1194N820ABVertical Air Inc · Deland, FLBuilt 2005 · S/N 116N820BHVertical Air Inc · Deland, FLBuilt 1989 · S/N 208B0153N820FEFederal Express Corporation · Memphis, TNBuilt 1992 · S/N 208B0111N820GMSecond Wind LLC · Tallahassee, FLBuilt 2024 · S/N 46020031N820RASteinke Matthew R · Gibson, IABuilt 2012 · S/N 502B-2876N820RDImhof Air 2 LLC · Ferndale, WABuilt 1973 · S/N LW-82N820RGMacys Flying Service Inc · Tulelake, CABuilt 2007 · S/N 402B-1195N821ARFairey Ltd · Las Vegas, NVBuilt 1974 · S/N 421N821JRegistration Pending · West Branch, MIRegistration pendingBuilt 2003 · S/N 4697172N8226ZUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-190N8227PUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-194N822LTMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2021 · S/N 100-0303N822MMBristow LLC · Lake Charles, LABuilt 2005 · S/N 14055N822STRk Aviation LLC · Phoenix, AZS/N EVO-026N823EBIdi Aviation LLC · Indianapolis, INBuilt 1998 · S/N FL-227N823XTransport Services LLC · Birmingham, ALS/N 823N8244LAircraft Partner N8244l Dst · Wilmington, DEBuilt 1992 · S/N NC-29N8254DWest Pacific Air LLC · Spokane, WABuilt 1991 · S/N EA-524N825BKKlein Flying Service · Lawrenceville, ILBuilt 1993 · S/N 402-0902N825KASav Aviation LLC · Jacksonville, TXS/N BB-825N825SDGreat Valley Management Inc · New Castle, DEBuilt 1996 · S/N LJ-1449N826FPMango Air 2 LLC · Oxnard, CABuilt 2000 · S/N FL-284N826XTransport Services LLC · Birmingham, ALBuilt 1985 · S/N 826N827DLGa Ventures LLC · Scott, LABuilt 1986 · S/N FA-103
Back to AD 2002-23-13