OpenAirDocs.org
AD 97-05-03 R1

Registered aircraft · 2,862

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:97-05-03-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-05-03-R1')
  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.

N560WHCenturion Air LLC · Windermere, FLBuilt 1989 · S/N 560-0013N560WRTree Top Aviation LLC · Lubbock, TXS/N 5600121N560WTCsw Aviation Services LLC · Dahlonega, GABuilt 1992 · S/N 560-0168N560WVN560wv LLC · Brunswick, GABuilt 1993 · S/N 560-0217N560WWJrnd Corp · Lewes, DES/N 560-0047N560ZSCape Romain Holdings LLC · Wilmington, DEFirst renewal noticeBuilt 1994 · S/N 560-0281N561BCInternational Bank Of Commerce · Laredo, TXBuilt 1998 · S/N 525-0257N561CCAir Land Leasing LLC · Madera, CABuilt 1997 · S/N 560-0416N561CFTitan Air LLC · Pasco, WAS/N 560-0003N561CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1991 · S/N 560-0099N561DAPark Avenue Group Inc · Stuart, FLBuilt 1995 · S/N 5600314N561FPZulu Romeo LLC · Ontario, ORBuilt 2001 · S/N 560-0561N561JSDodson International Parts Inc · Rantoul, KSBuilt 1997 · S/N 5600413N561MTN561mt LLC · Clovis, NMBuilt 1991 · S/N 560-0122N561PAJmrkfly LLC · Naples, FLS/N 560-0116N561PFN561pf LLC · Richland, WABuilt 1990 · S/N 560-0048N561SRChrysler Aviation Inc · Van Nuys, CABuilt 1991 · S/N 560-0138N561WFDm Air LLC · Pasco, WABuilt 1992 · S/N 560-0182N562CLGrandview Air LLC · Eldridge, IAS/N 560-0768N562PCDelta Farm Express LLC · Richview, ILBuilt 1996 · S/N 525-0151N562RMMas Aircraft Leasing LLC · Missoula, MTBuilt 1990 · S/N 550-0646N563DDTextron Aviation Inc · Wichita, KSS/N 525-1428N563MMenard Inc · Eau Claire, WIBuilt 2001 · S/N 560-0550N563TMAlamance Aviation LLC · Wilmington, DEBuilt 1991 · S/N 5600124N564MMenard Inc · Eau Claire, WIBuilt 2001 · S/N 560-0569N564TBK3hw LLC · Pattison, TXBuilt 1991 · S/N 560-0141N564TJBranch Aircraft Leasing Inc · Ocala, FLBuilt 1997 · S/N 560-0432N565ARAr Aviation Group LLC · Springfield, ORBuilt 2000 · S/N 550-0919N565GGN1130j LLC · Huntsville, TXBuilt 1990 · S/N 5500643N565SKM&N Equipment LLC · Englewood, COBuilt 2002 · S/N 258604N565TTWright Tony Lee · Douglas, GABuilt 1989 · S/N 560-0023N566KBT3 Farms LLC · Godley, TXBuilt 1995 · S/N 560-0325N566VRR & C Aviation LLC · Vancouver, WABuilt 1998 · S/N 560-0480N567BWDac Air LLC · Lakewood Ranch, FLBuilt 2018 · S/N 525-0983N567RWBuffalo Bayou Air LLC · Houston, TXBuilt 1996 · S/N 560-0394N568BBank Of Utah Trustee · Salt Lake City, UTS/N 560-0481N568JCN568mh LLC · Sunnyside, WABuilt 1994 · S/N 5600283N568PACff Air Inc · Wilmington, DEBuilt 1978 · S/N 205N568STRegistered aircraftBuilt 1987 · S/N 550-0565N568TXSpray Brothers Aviation LLC · Great Bend, KSBuilt 2001 · S/N 560-0558N569CCRebel Aircraft LLC · Rapid City, SDBuilt 2005 · S/N 550-1113N569HADe Paz Aviation LLC · Coral Gables, FLS/N 258773N569LMWitza B LLC · Saginaw, MIBuilt 1990 · S/N 560-0068N569TASav Aviation LLC · Jacksonville, TXBuilt 1989 · S/N 560-0006N56FSSunny Skies Kc LLC · Leawood, KSBuilt 2002 · S/N 560-0600N56KGBlue Yonder LLC · Portland, ORBuilt 2001 · S/N 560-0563N56MKTs Investments LLC · Dallas, TXBuilt 1998 · S/N 560-0453N56TFWoodbine Aviation LLC · Akron, OHS/N 560-0014N56XPEverair LLC · Niagara Falls, NYBuilt 2016 · S/N 525-0904N570CJJe Consulting LLC · Geneseo, ILFirst renewal noticeBuilt 2020 · S/N 525-1051
Back to AD 97-05-03 R1