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.

N321BWAero Marine Inc · Westland, MIBuilt 1966 · S/N D-8343N321CEMaroon Sky LLC · Navasota, TXBuilt 1981 · S/N 421C1225N321CFTekswork Aviation LLC · London, KYBuilt 2002 · S/N 0304N321DBDc Aviation Maintenance Inc · Bryant, ARBuilt 1978 · S/N CE-797N321DDGreene Jonathan U · Pompano Beach, FLBuilt 1980 · S/N TJ-278N321DGAdkison Edy P · Riverside, CABuilt 1969 · S/N 21059201N321DWJsj LLC · Wilmington, DEBuilt 1979 · S/N 310R1823N321HDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 414-0625N321HASkytook LLC · Wilmington, DEBuilt 1973 · S/N 421B0420N321JHSkidmore Gary DBA · Terreton, IDBuilt 1978 · S/N 414A0063N321JJJayjet Private Aircraft Charter LLC · Swanton, OHBuilt 2004 · S/N 1113N321JPAzure Skyes Holdings LLC · Poulsbo, WABuilt 1980 · S/N 18504166N321JRAcademy Aviation Services LLC · Cedar Park, TXBuilt 1982 · S/N EA-289N321JTPcss Aviation LLC · New Albany, MSBuilt 2001 · S/N EA-670N321LGLaughing Gull Aviation Inc · Fort Lauderdale, FLBuilt 1978 · S/N 21062769N321MMJohnson Curtis A · St Paul, MNBuilt 1979 · S/N 18503976N321MTIflyhi Aviation LLC · Sanbornton, NHBuilt 2005 · S/N 1696N321NOatman Scott A · Colorado Springs, COBuilt 1968 · S/N TE-583N321RHTorrey Daniel B · Ojai, CAS/N 74-30657N321RPIsrael Oscar M III · Sinton, TXBuilt 1973 · S/N 340-0201N321RR321 Rr Lp · Wimberley, TXBuilt 1968 · S/N TE-520N321TBMob Aviation USA LLC · Auburndale, FLBuilt 1982 · S/N E-1998N321WMMartinez Jose A · Orlando, FLBuilt 1975 · S/N TH-571N321WPRadmall LLC · Commerce City, COBuilt 1995 · S/N E-2929N321WRFord Paul · Princeton, NJBuilt 2002 · S/N 0269N321WVHill Stephen D · Lincoln, NEBuilt 2012 · S/N TH-2343N321WYWhitescarver Suzanne L Trustee · Las Vegas, NVBuilt 2016 · S/N L2K-273N3220JFagen Inc · Granite Falls, MNBuilt 1995 · S/N E-2920N3222PAmlz Air LLC · Rockville, MDBuilt 1995 · S/N EA-573N3222UMilpower Inc · Nampa, IDBuilt 1995 · S/N E-2919N3223BTechmur LLC · Loudonville, NYBuilt 1995 · S/N E-2923N3224QRech Jack R · Mohave Valley, AZBuilt 1999 · S/N E3224N3225KWjm Aviation LLC · Friendswood, TXBuilt 1995 · S/N E-2975N3226BSooner Aviation LLC · Norman, OKBuilt 1999 · S/N E3226N3226JSimms Matthew · Davie, FLBuilt 1994 · S/N E-2855N3226QDenning Aviation Inc · Fort Madison, IABuilt 2000 · S/N E-3326N3227ABoho LLC · Lewes, DEBuilt 1980 · S/N 310R1881N3227GOgden Scott S · Collierville, TNBuilt 1995 · S/N E-2927N3227XSasar Inc · Wilmington, DEBuilt 1999 · S/N E-3227N3228WChris I Lee Md Inc · Rowland Heights, CABuilt 1995 · S/N E-2928N3228XN3228x LLC · Colusa, CABuilt 1995 · S/N E-2978N3229GAero-Mark LLC · Winchester, KYBuilt 2000 · S/N E-3329N322CDGnc Industries Inc · Pocahontas, ARBuilt 2005 · S/N 1272N322CWGallagher Maria J · Lakewood Ranch, FLBuilt 2004 · S/N 1098N322ETWing Bird Aviation LLC · Garland, TXBuilt 1975 · S/N TE-1016N322FMeikle Ted S Trustee · Ephraim, UTBuilt 1969 · S/N CE-283N322HAAir Flight Inc · Fort Lauderdale, FLS/N 402C0418N322HSReed Systems Ltd · Ellenville, NYBuilt 1974 · S/N D-9709N322JBJ & R Aviation Inc · Sioux Falls, SDBuilt 1990 · S/N E-2549N322LKFindley Air LLC · Temecula, CABuilt 1974 · S/N 21060344
Back to AD 86-13-04 R3