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.

N5020RMigliaccio Jason · Palm Bay, FLBuilt 1974 · S/N 17263261N5020SSchneider Robert R · Fort Benton, MTS/N 28R-35753N5020TBetlach Christopher Thomas · Kenmore, WABuilt 1972 · S/N 28R-7235175N5020WAndersen Richard W · Vail, AZBuilt 1961 · S/N 28-21N5020YStandridge Robert M · Norman, OKS/N 3246187N5021HAlamo Flyers LLC · Elmendorf, TXBuilt 1975 · S/N 17265304N5021RWax Sally G · Louisville, KYBuilt 1974 · S/N 17263262N5022WHovendick William P · Lander, WYBuilt 1961 · S/N 28-23N5023LIsland Hoppers Seaplanes 2 LLC · Orlando, FLBuilt 1971 · S/N 480N5023RStern Joseph L · Morrow, OHBuilt 1974 · S/N 17263264N5023SSummit Arrow Adventures LLC · Peyton, COBuilt 1970 · S/N 28R-35759N5023YAas LLC · Ovid, MIBuilt 1962 · S/N 27-2027N50240Carr James T · Scotts, MIBuilt 1978 · S/N 436-78N50246Taubman Jason · Greenland, NHBuilt 1978 · S/N 1052-78N50247Haywood Charles E Jr · Valrico, FLS/N 437-78N5024PSun Aviation Inc · Santa Clara, CABuilt 1958 · S/N 24-27N5024SGuy Timothy S · Henderson, NVBuilt 1970 · S/N 28R-35760N5024TMoore Jason J · Spanish Fort, ALBuilt 1972 · S/N 28-7225320N50259Coker Steve L III · Tyler, TXBuilt 1978 · S/N 441-78N5025CSamalon William S Trustee · Juneau, AKBuilt 1978 · S/N 1053-78N5025DCal-Aerofab Flight Academy Inc · Chino, CABuilt 1978 · S/N 366-78N5025EStokes Field LLC · Mount Vernon, MOBuilt 1978 · S/N 438-78N5025FAllen Scott L · Ogallala, NEBuilt 1978 · S/N 1054-78N5025PFoley Jeffrey W · Scappoose, ORBuilt 1978 · S/N 440-78N5025QAppel Joshua D · Redfield, SDS/N 1056-78N5025SAir Cover Academy LLC · Frankford, MOBuilt 1970 · S/N 28R-35761N5025TRoney William A · Santa Fe, NMBuilt 1972 · S/N 28-7225321N5026BLaurie Craig M · Anchorage, AKBuilt 1978 · S/N 442-78N5026ETurner Greg W · Delta Junction, AKBuilt 1978 · S/N 1057-78N5026GJohnson Steven L · Salol, MNBuilt 1978 · S/N 1058-78N5026NWright Bruce M · Rosharon, TXBuilt 1979 · S/N 570-79N5026RSwinney Marty Sherman Trustee · Macomb, OKBuilt 1974 · S/N 17263267N5026WSpencer Don W · The Dalles, ORBuilt 1961 · S/N 28-27N50271Sawyer Johnson Inc · Osceola, WIBuilt 1979 · S/N 572-79N5027FAmoia Steven M · La Mesa, CABuilt 1979 · S/N 571-79N5027KMchale Thomas Alexander II · El Paso, TXS/N 1176-79N5027NMargolin Donald B · Santa Barbara, CABuilt 1979 · S/N 1187-80N5027RVentura Hector E · Vieques, PRS/N 17263268N5027SRatliff Thomas E · Tomball, TXS/N 28R-35771N5027TMohre Steve G · Blakeslee, OHBuilt 1972 · S/N 28R-7235177N5027WJohnson Dennis E · Factoryville, PABuilt 1961 · S/N 28-28N5028FMarshall Kevin · Dekalb, ILFirst renewal noticeBuilt 1979 · S/N 573-79N5028GButler Patrick F · Elko, NVBuilt 1979 · S/N 574-79N5028LBarla Joel · Eaton Rapids, MIBuilt 1971 · S/N 485N5028SSmith David J · Elkhart, INBuilt 1970 · S/N 28R-35772N5028TDrake Charles R · Claremore, OKBuilt 1972 · S/N 28R-7235178N5028VFlying Lemur Inc · Alexandria, VABuilt 1978 · S/N 445-78N50291Euros Aircraft Leasing LLC · College Station, TXBuilt 1974 · S/N 17264199N5029ETimmins Christian · Covington, LABuilt 1978 · S/N 367-78N5029GArnold Michael P · Boise, IDBuilt 1978 · S/N 288-78
Back to AD 87-10-06 R1