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.

N3822TVanderblom David Y · Oxford, ALBuilt 1967 · S/N 28R-30139N3823FGovednik Francis J · Flower Mound, TXBuilt 1977 · S/N 0791N3823WCherokee N3823w LLC · Huntsville, ALFirst renewal noticeBuilt 1966 · S/N 32-755N3823ZFranks Cory B · Idalou, TXBuilt 1960 · S/N 18-7563N38248Plane Training LLC · Rapid City, SDBuilt 1977 · S/N 28-7716234N3824MDraveling Larry J · Wasilla, AKFirst renewal noticeBuilt 1947 · S/N 12-2744N3824RAbove All Aviation Inc · Santa Barbara, CABuilt 1980 · S/N MC-741N3824TStevens Zane Kelly · Carthage, TNBuilt 1967 · S/N 28R-30141N3824WTeel Brian P · Hooper, UTBuilt 1966 · S/N 32-756N3824ZMoore Ricky J · Milton, KYBuilt 1980 · S/N MC-644N38250Elkins John H · Lancaster, MABuilt 1977 · S/N 28-7790531N38254Syracuse Flying Club Inc · Fayetteville, NYBuilt 1977 · S/N 28-7790534N38256Ringler Neil H · Baldwinsville, NYBuilt 1977 · S/N 28R-7737085N3825QFischer Roger G · Torrance, CABuilt 1971 · S/N 17259925N3825TArmstrong Aviation Services LLC · Freeport, PABuilt 1967 · S/N 28R-30143N3825WKaizen Companies Inc · Boise, IDBuilt 1966 · S/N 32-757N38265Recipe System US Inc · Torrance, CABuilt 1977 · S/N 28-7716236N38267Andy Mack Management LLC · Wilmington, DEBuilt 1977 · S/N 28-7716237N3826PBauries Brian W · Abilene, TXBuilt 1955 · S/N 22-3516N3826WMiller Heather J · Dupo, ILBuilt 1966 · S/N 32-759N3826ZWebster William S · Eden, WYBuilt 1961 · S/N 18-7569N38273Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-7737086N38276N38276 LLC · Las Vegas, NVBuilt 1977 · S/N 32-7740081N3827MFox James Douglas · Pittsburg, ILBuilt 1978 · S/N 28-7890335N3827TBrauer Noah J · Covington, KYBuilt 1967 · S/N 28R-30145N3828PPupator Peter Trienko · Willow, AKBuilt 1955 · S/N 22-3518N3828ZOrvin Sanden Inc · Wyndmere, NDBuilt 1960 · S/N 18-7571N38291Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7716240N38293L & A Bennett Second Family L P · Renton, WAS/N 28-7790537N38294Aerograzmar LLC · Bloomfield, NJBuilt 1977 · S/N 28R-7737087N3829QMiller Randall J · Arlington, WABuilt 1971 · S/N 17259929N3829TFreese Pamela L · Frederic, WIBuilt 1967 · S/N 28R-30147N3829XFerrari Martin · Centerville, OHBuilt 1981 · S/N M-2306N382AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281192N382BTPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010086N382CCVeenstra Timothy S · Wasilla, AKS/N 9946CCN382DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843845N382DFDream Flight LLC · Westminster, MDBuilt 1976 · S/N 17268233N382HP382 Hp LLC · Pt Pleasant Beach, NJBuilt 2006 · S/N 3257411N382JMGullicksrud Mark Robbe · Strum, WIBuilt 1981 · S/N 32R8229026N382JNSilver Sky Air LLC · Fresno, CABuilt 1973 · S/N 17262794N382MAFly To Sea LLC · Stanford, CABuilt 2004 · S/N 487-2004N382NHendren Ronald P · Clarkston, MIBuilt 1977 · S/N AA5A0519N382NDUniversity Of North Dakota · Grand Forks, NDBuilt 2024 · S/N 2881828N382XAnderson David C · Dilley, TXBuilt 1976 · S/N 7021CN383Martis Valley Aviation LLC · Redwood City, CABuilt 1981 · S/N ME-388N38305Wulf Aerospace LLC · Santa Rosa Beach, FLBuilt 1977 · S/N 32R-7780413N3830PHeckerman Ted A · Canyon Lake, TXBuilt 1955 · S/N 22-3520N3830QAero Place Flyers Inc · Urbana, ILBuilt 1971 · S/N 17259930N3830TStevenson Shane C · Sicklerville, NJBuilt 1967 · S/N 28R-30148
Back to AD 87-10-06 R1