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.

N636JHTriple A Aviation LLC · Camden, DEBuilt 2016 · S/N E-4093N636KBRiviera Glass Flyers Inc - Trustee · Wichita, KSBuilt 2004 · S/N 1000N636KKKnox Construction Inc · Verdi, NVBuilt 1977 · S/N 340A0290N636MRGarrison Rodney · Atlanta, TXBuilt 2005 · S/N E-3639N636RALoyd Randolph · Gassville, ARBuilt 1999 · S/N E-3229N636RPSterling Creek Aviation LLC · Llano, TXBuilt 2008 · S/N E-3882N636TCChamberlain David C · Keller, TXBuilt 1987 · S/N EA-463N6370SFreeland Christopher G · Brownwood, TXS/N D-9832N6371BOakley Collier Architects P A · Rocky Mount, NCBuilt 2010 · S/N E-3927N6375XMiliano Air LLC · Lewes, DEBuilt 1978 · S/N 402B1338N6376SGray James W · Cypress, TXBuilt 1975 · S/N CE-619N637BEJzl Corp · Fort Collins, COBuilt 1984 · S/N 46-8508018N6384XPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1978 · S/N 402B1347N63858Skyway Aviation Inc · Jackson, MIS/N TH-1360N6385HEds Used Machinery LLC · Memphis, MOS/N 30104N6385PBada Alfredo · Mcallen, TXBuilt 1978 · S/N P21000173N6385UHilde Chadwick Q · Memphis, TNBuilt 1982 · S/N EA-290N6387UWeyermuller Scott P · Bossier City, LAS/N EA-291N6387XAir Exec Inc · Mount Pleasant, IABuilt 1978 · S/N 402B1350N6388PMurfin Drilling Co Inc · Wichita, KSBuilt 1981 · S/N E-1991N6388YMaclean Kenneth J · Northborough, MABuilt 1981 · S/N 21064359N6389UBender & Lammers LLC · Bennington, NEBuilt 1982 · S/N EA-294N6389WSpenco Inc · Sale Creek, TNBuilt 1981 · S/N P21000764N638CDAlt Av LLC · Bossier City, LABuilt 2011 · S/N E-3969N638LDDion Aviation LLC · Key West, FLBuilt 1976 · S/N TH765N638LLFire Island Flight LLC · Islip, NYS/N G-93N638PClements Scott · Royse City, TXBuilt 1981 · S/N EA-209N638SDebonair N638s Flying Club LLC · Beavercreek, OHBuilt 1967 · S/N CE-170N638WCBrown Everette · Edenton, NCBuilt 1975 · S/N TH-632N6391UGimli Son LLC · Fort Lauderdale, FLBuilt 1979 · S/N U20605472N6392CTretter Nicholas · Holden, MABuilt 1980 · S/N 21063880N6392ZFlorence Michael · Portsmouth, NHBuilt 1981 · S/N U20606264N63936Sea & Ski Nw LLC · Portland, ORBuilt 1982 · S/N E-2053N6393SRegistered aircraftBuilt 1975 · S/N CE-623N6394DManzur Miguel Antonio · Mcallen, TXBuilt 1977 · S/N 21062010N6395ZN Berk Consultant Inc · Greenwich, CTBuilt 1981 · S/N U20606266N6396XAviation Tech Services LLC · Edgewater, FLBuilt 1978 · S/N 402B1355N6397BLayson Walter E · Calhoun, GABuilt 1978 · S/N 21062758N6397ENorth Country Aviation Aircraft Leasing LLC · Bingham, MEBuilt 1980 · S/N 18504039N6397SIts Allgood Air LLC · Lewes, DEBuilt 1975 · S/N D-9833N6397YAsher James A · Pasadena, CABuilt 1981 · S/N 21064363N6398WPivac Jorge I · Chandler, AZBuilt 1982 · S/N P21000767N6398YSinglepoint Technologies Corp · Richmond, VABuilt 1981 · S/N 21064364N6399KI B Development LLC · Monahans, TXBuilt 1979 · S/N P21000397N639ARBraden Health LLC · Greensboro, NCBuilt 2000 · S/N TH-1968N639FSC&Bh LLC · Vernal, UTBuilt 1980 · S/N P210-00639N639SCSale Reported · Glen Allen, VASale reportedBuilt 1969 · S/N 421A0102N63BHN63bh LLC · Auburn, ALBuilt 1977 · S/N E-1186N63BMDayton Aircraft Services Inc · Daytona Beach, FLS/N E-3410N63ETNelson Edward T · Silver Springs, FLBuilt 1999 · S/N 07-265
Back to AD 86-13-04 R3