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.

N317BDRegistered aircraftBuilt 1967 · S/N TE-317N317CAspn Aero LLC · Ostrander, OHBuilt 1995 · S/N EA-574N317CDBluecore Leadership LLC · Reston, VABuilt 2004 · S/N 0905N317CHCrestair Air LLC · Dover, DEBuilt 1973 · S/N D-9543N317EPMcelligott Michael J · Woodstock, VABuilt 1969 · S/N D-9044N317RDelaney Jeffrey Stephen · Arlington, TNBuilt 2003 · S/N 0495N317SCDuehring Jonathan H · Raleigh, NCBuilt 1968 · S/N D-8754N317TRRcs Aeronautical Inc · San Antonio, TXBuilt 1973 · S/N 310Q0787N3180WPepe Charles · Morrisville, VTBuilt 1974 · S/N D-9574N3181UBig Sky Aviation LLC · Ridgeland, MSBuilt 1994 · S/N EA-563N3181WNormark Jordan C · Granbury, TXBuilt 1974 · S/N D-9575N3182LN303cj LLC #1 · Lexington, KYBuilt 1999 · S/N TH1882N3182WOutstate Air Taxi Inc · Windom, MNBuilt 1974 · S/N CE-482N3185CThree Pipers Piping LLC · Charleston, SCBuilt 2000 · S/N E-3324N3187WG S Aviation Inc · Stilwell, KSBuilt 1974 · S/N TH-428N3189MSnowbird Aviation Corp · Signal Mountain, TNBuilt 2000 · S/N E-3325N3189YSkotynsky Michael · Broomfield, COBuilt 2001 · S/N E-3389N318ALeaders Robert O · Clear Lake, MNBuilt 1966 · S/N TE-229N318CAKornegay Patrick · Harlingen, TXBuilt 2001 · S/N TH-2001N318DSchutes John T · Brimfield, MABuilt 1967 · S/N TE-311N318GAero Fliers Inc · Akron, OHBuilt 1966 · S/N CE-71N318NRNorthern Arizona Investment Group LLC · Prescott, AZBuilt 1982 · S/N 18504382N318PPK&A Consulting Of Montana Inc · Billings, MTBuilt 1974 · S/N 421B0843N318TWFlg Air Transport LLC · Miramar, FLS/N 421-0170N318UTraffic Law LLC · Tampa, FLBuilt 1977 · S/N 310R0994N318WTThompson Brent D · Bloomington, INBuilt 2003 · S/N 0474N3191APasternak Eliezer Trustee · Palo Alto, CABuilt 1999 · S/N E-3291N3192WJ M Beech Inc · Wilmington, DEBuilt 1974 · S/N E-521N3193XBlh Visions Mt LLC · Polson, MTBuilt 1994 · S/N E-2907N3194CNortje Bryan John · Gold Hill, NCBuilt 1967 · S/N D-8479N3194XAutry Mark T · Sumter, SCBuilt 1994 · S/N TH-1723N3195KEasygoair LLC · Sudbury, MABuilt 1999 · S/N TH-1895N3195MAspire Management Inc · New Castle, DEBuilt 1980 · S/N 310R1868N3196AKloker Daniel E · Owasso, OKBuilt 1994 · S/N E-2885N3196WTs Aviation LLC · Sioux Falls, SDBuilt 1999 · S/N TH-1913N3197MBonanza Five Flying Club Inc · Roswell, GABuilt 1994 · S/N E-2887N3198LKatsahnias George T · Denton, TXBuilt 1994 · S/N E-2898N3199DHebda Thomas W · Colorado Springs, COBuilt 1994 · S/N EA-566N3199GDriftless Aviation LLC · Wilmington, DEBuilt 1994 · S/N E-2890N3199HHills Holding · Newark, DEBuilt 1994 · S/N E-2891N3199JSietsma Lawrence F · Indialantic, FLBuilt 1999 · S/N TH-1899N319CAAcree James · Euless, TXS/N TK93N319GSilver Star Holdings LLC · Aurora, COBuilt 2002 · S/N 0319N319JFRegistration Pending · Johns Island, SCRegistration pendingS/N 21063507N319MPAccelerated Development Organization · Hampton, VABuilt 2002 · S/N 0287N319RFFairfax Ronald E · Hailey, IDBuilt 1974 · S/N D-9663N31AEBrown Brent W · Farmington, UTBuilt 1997 · S/N 001N31AWRestoration Dental · Chesterfield, MOBuilt 1975 · S/N 414-0803N31BXWhite Robert · Woodlawn, TNBuilt 1986 · S/N 46-8608031N31CCRegistered aircraftBuilt 1967 · S/N 370
Back to AD 86-13-04 R3