OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,010

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:87-10-06-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:87-10-06-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.

N5548HYoungs Erin M · Gillette, WYS/N 1248N5548QKlassic Rides LLC · Newton, NCBuilt 1991 · S/N 1250N5548SGardner Timothy J · Gardnerville, NVS/N R18201606N5548UMorales Ramos Abdiel · Tucson, AZBuilt 1969 · S/N 28-26272N55497Murphy David B · Germantown, MDBuilt 1973 · S/N 28-7325419N55498Burke Monte D · Dallas, TXBuilt 1973 · S/N 28-7325420N5549JLombardi Steven · Edgewood, TXBuilt 1967 · S/N 32-1011N5549NRfd Aero LLC · Wilsonville, ORBuilt 1980 · S/N 18267784N5549UFar From Cheap LLC · Wichita Falls, TXBuilt 1969 · S/N 28-26273N5549WFons Wlliam M · Oconomowoc, WIBuilt 1962 · S/N 28-640N554DDale Wes · Gainesville, GABuilt 1962 · S/N TD-507N554DKRvest Management LLC · Boulder City, NVS/N 502-2007N554FLTomenyaero Inc · Florence, ORS/N 28-7125393N554GLConcho Aviation LLC · Sterling City, TXBuilt 2002 · S/N 3399N554HSouthworth Elizabeth A · Igo, CABuilt 1976 · S/N 1039N554JCCouch Kent E · Bend, ORBuilt 1955 · S/N 18-4132N554KDWestern Air International Co · Pompano Beach, FLBuilt 1979 · S/N 31-7952157N554LBSons Family Enterprises LLC · Wichita Falls, TXS/N 28-10250N554LHKretchmer Daniel R · Northfield, MNBuilt 2009 · S/N 90554N554MMHodges Damon · Omaha, TXBuilt 2022 · S/N CCK-1865-1072N554PAGerken Nicholas C · Anacortes, WABuilt 1972 · S/N 28-7225475N554PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842091N554RRegistered aircraftBuilt 1976 · S/N 28-7690382N554RVSullivan Michael · Columbia, SCS/N 24710N554WMValdosta Flying Group LLC · Valdosta, GAFirst renewal noticeBuilt 2005 · S/N 18281666N55502Blue Valley Flying Club Inc · Denton, NES/N 28-7305401N55504University Cherokee Club LLC · Lincoln, NEBuilt 1973 · S/N 28-7305402N55505Bothwell Brandon W · Mooresville, MOS/N 28-7305403N55506Lugo Rullan Javier A · Adjuntas, PRBuilt 1973 · S/N 28-7325424N5550JOptima Aviation LLC DBA · Lewisville, TXBuilt 1980 · S/N 17273818N5550MHamblin Michael J · Seatac, WABuilt 1967 · S/N 088N5550QReal Jonathan Dan · La Jolla, CABuilt 1965 · S/N 628N5550UFarm Air Service Inc · Pingree, NDBuilt 1969 · S/N 28-26274N5550WStone Oren · Erick, OKS/N 28-641N55510Western Community College Area DBA · Scottsbluff, NES/N 1252N55513Spoon River Flyers Inc · Avon, ILBuilt 1973 · S/N 28-7305405N55514Loomis Christopher · Cumming, GABuilt 1973 · S/N 28-7305406N55515Fly Cessna LLC · Peoria, AZBuilt 1981 · S/N 17275195N55516On Glideslope LLC · Middletown, DEBuilt 1973 · S/N 28R-7335247N55517Loye Mark C · Reidsville, NCBuilt 1973 · S/N 28-7310146N5551FFriest Eric J · Menomonie, WIBuilt 1968 · S/N 28-24890N5551KSchlamer Robert B · Hernando, FLBuilt 1978 · S/N 400-78N5551PLarsen Jordan · Draper, UTS/N 24-616N5551QQualitair LLC Trustee · MichelstadtS/N 1276N5551UBriese Mathew · Rochester, MNBuilt 1991 · S/N 1277N5551WMurdter Lawrence M · Sunnyvale, CABuilt 1962 · S/N 28-642N55521Carter Flygare Inc · Sacramento, CABuilt 1981 · S/N 17275196N55525Gustafson Michael Luther · Groveland, CABuilt 1973 · S/N 28-7325426N55529Carrozzella Christopher · Wallingford, CTS/N 28-7305407N5552EAbove And Beyond Aviation LLC · Austin, TXS/N 17271887
Back to AD 87-10-06 R1