OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,497

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

N3120MCowtown Aviation LLC · Aledo, TXBuilt 1987 · S/N CE-1204N3121WAlpha Dog Aviation LLC · Marco Island, FLBuilt 1973 · S/N TH-410N3122MMiller-Jackson Co Inc · Oklahoma City, OKBuilt 1984 · S/N EA-416N3122RMarrow Henry G · Southern Pines, NCBuilt 1994 · S/N TH-1722N3122UTravel Aviation Inc · Vineyard Haven, MABuilt 1988 · S/N E-2431N3123WSullivan Dan · Kingwood, TXBuilt 1973 · S/N E-500N3124WBaron 24w LLC · Outing, MNBuilt 1973 · S/N TH-411N3127WWalkcon Holdings LLC · Amarillo, TXBuilt 1988 · S/N E-2433N3128WSterling Anthony K · Wilson, NCBuilt 1973 · S/N D-9564N31291N31291 Aviation LLC · Omro, WIBuilt 1988 · S/N E-2432N3129UJones Robert M · Brooksville, FLBuilt 1988 · S/N CE-1255N312ADAltier Daniel T · Bloomfield Twp, MIBuilt 2005 · S/N 1615N312CRMjk Air LLC · Estes Park, COS/N E-23N312CSFlybuys3 LLC · Lewes, DEBuilt 1977 · S/N 310R0959N312CWLb Wings LLC · Midland, MIBuilt 1981 · S/N TH-1204N312DKline Robert H · Oley, PABuilt 2000 · S/N 29-0255N312DATspy Services Inc · Wilmington, DEBuilt 2005 · S/N 1262N312SCBarker Family Investments Management Co LLC · Tyler, TXBuilt 1981 · S/N 21064474N3130QDobbs Peter J · Duluth, MNBuilt 1981 · S/N 18504322N3131BShilman Nathaniel · Dickinson, NDBuilt 1973 · S/N 73-30565N3131KAmazon Aero Corp · Wilmington, DEBuilt 1972 · S/N 402B0248N3132WSteve Rodemer Esq LLC · Colorado Springs, COBuilt 1973 · S/N CE-477N3135WFlycarolina LLC · Concord, NCBuilt 1973 · S/N D-9538N31368Anderson Aviation Inc · Anderson, SCBuilt 1955 · S/N 140755N3136XBobbett Robert Todd · West Richland, WABuilt 1998 · S/N EA-620N3138WN3138w Bonanza V35b LLC · Jeffersonville, INBuilt 1973 · S/N D-9566N3139LOn Premise LLC · Hannibal, MOBuilt 1987 · S/N CE-1143N3139WGrace Air LLC · Kalispell, MTBuilt 1973 · S/N E-503N313DG3dg Aviation LLC · Louisville, KYBuilt 2005 · S/N 1592N313GBBurnett Gregory C · Rogersville, MOBuilt 1977 · S/N 21061986N313GMEugene C Warne Trustee · Alamo, CABuilt 2009 · S/N E-3907N313MBosco74 LLC · Wilmington, DEBuilt 1963 · S/N 500A-1276-99N313MPAlpha Bravo Charlie 1 Corp · Houston, TXBuilt 1980 · S/N P21000573N313RJNew Hampshire Flying Association Inc · Nashua, NHS/N CE-911N313RWSarp Rentals LLC · Loudon, TNBuilt 1969 · S/N 414-0010N313TF313tf Aviation LLC · Superior, WIBuilt 2004 · S/N 1237N313WWilliams Thomas James · Clovis, CABuilt 1981 · S/N D-10363N313WTCinotto Robert L · Rhome, TXBuilt 1979 · S/N P21000350N31444Crossen John R · San Pedro, CABuilt 1988 · S/N CE-1277N3144HT And C Corp · Wilmington, DEFirst renewal noticeBuilt 1987 · S/N CE-1191N3144MWhite Ice Holdings LLC · Santa Rosa Beach, FLBuilt 1987 · S/N CE-1206N3144YSierra Bravo Zulu LLC · Middletown, DES/N E-2437N3145WIfly Aviation LLC · Conway, ARBuilt 1973 · S/N E-505N3146WWalker Ernest F · Bala Cynwyd, PABuilt 1973 · S/N CE-479N3147LBrowning Charles H III · Woodbine, MDBuilt 1994 · S/N E-2882N3147WTadesco Rothchild LLC · Wilmington, DEBuilt 1973 · S/N D-9569N3148PSky Hi Aviation LLC · Wilmington, DEBuilt 1977 · S/N 210-61945N31494Locker Aircraft Inc · Muleshoe, TXBuilt 1988 · S/N CE-1269N31497N400sr LLC · Astoria, NYBuilt 1988 · S/N CE-1275N314DGLaminar Holdings LLC · Sheridan, WYBuilt 2007 · S/N 260
Back to AD 86-13-04 R3