OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,015

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-20-03-R2')
    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-20-03-R2')
  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.

N6816BMystic Dreams LLC · Mount Juliet, TNBuilt 1978 · S/N 21062837N6817ACerminara Giovanni · Belleview, FLBuilt 1956 · S/N 28917N68184Wichita Area Technical School · Wichita, KSBuilt 1978 · S/N 15282170N6818EHurt Randall L · Smithville, TNS/N 56318N6818FBell Douglas W · Mattoon, ILBuilt 1966 · S/N 15063418N68195Richmor Aviation Inc · Scotia, NYBuilt 1978 · S/N 15282177N68197Smtm Holdings Inc · Wilmington, DEBuilt 1978 · S/N 15282178N68198Jw Plane Leasing LLC · Wausau, WIBuilt 1978 · S/N 15282179N6819GJ & J Holdings LLC · Warren, MIBuilt 1970 · S/N 15072319N681JBJuliet Bravo Aviation LLC · South Padre Island, TXBuilt 1980 · S/N R18201672N681RLWeatherby Thomas M · Rcho Sta Marg, CAS/N 28633N68206Fs Investments LLC · White Lake, MIBuilt 1978 · S/N 15282184N6820GJensen Eric Gunnar · Ogden Dunes, INBuilt 1970 · S/N 15072320N68211American Aviation Inc · Brooksville, FLS/N 15282188N68212Dynasty Adventure Inc · Mentone, CABuilt 1978 · S/N 15282189N68215New Mexico Flying Eagle Inc · Tucson, AZS/N 15282191N6821AArmiger Scott Linwood · Holly Springs, NCBuilt 1956 · S/N 28921N6821EPriest Justin E · Arlington, WABuilt 1959 · S/N 56321N6821GMueller Carla I · Lexington, SCS/N 15072321N6821XTudorani Vincenzo C · Las Vegas, NVS/N 47721N68220Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282194N68225Brown Steven E · Paynesville, MNBuilt 1978 · S/N 15282198N68228Van Thomme Wayne A · Faribault, MNBuilt 1981 · S/N 15285320N6822AStewart Brock Allen · Bartlett, TNBuilt 1956 · S/N 28922N6822GKnot Enough Airspeed LLC · Oshkosh, WIBuilt 1970 · S/N 15072322N6822MSunnysideup LLC · Las Vegas, NVBuilt 1975 · S/N 18263849N68234Bryant William E · Fort Bragg, NCBuilt 1978 · S/N 15282203N68237Registration Pending · Tacoma, WARegistration pendingBuilt 1978 · S/N 15282204N6823AWilliams Daniel H · Fort Mcdowell, AZBuilt 1956 · S/N 28923N6823HClay Howard C II · San Francisco, CAS/N 17265596N6823XTipton Wendell D · Anchorage, AKBuilt 1960 · S/N 47723N68242Wilson Timothy J · Arlington, AZBuilt 1978 · S/N 15282205N68246M2g Aviation LLC · China Grove, NCBuilt 1978 · S/N 15282208N6824AChristenson Robert E · Anacortes, WABuilt 1956 · S/N 28924N6824RSquadron 5 Inc · Saratoga, CABuilt 1966 · S/N T210-0224N68257Bates Steven B · Phelan, CAS/N 15282213N6825ABarker Jason · Hampton Falls, NHBuilt 1956 · S/N 28925N6825FKieffer Jason M · Omaha, NEBuilt 1966 · S/N 15063425N6825GRhodes Bruce A · Santa Cruz, CABuilt 1970 · S/N 15072325N68260Flycarolina LLC · Rock Hill, SCBuilt 1978 · S/N 15282214N682666s Aviation Corp · Orlando, FLBuilt 1978 · S/N 15282218N6826BDan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1978 · S/N 21062840N6826ERudolphi Ben M · Valdosta, GAS/N 56326N6826FJeppesen Thomas L · Stanton, MIBuilt 1966 · S/N 15063426N6826GStar Voyages LLC · Kissimmee, FLS/N 15072326N68278Ilmberger Steve J · San Leandro, CAS/N 15282225N6827GBrooks Jeffrey C · Bridgeton, NJBuilt 1970 · S/N 15072327N6827XCalderon Daniel C · Castro Valley, CABuilt 1960 · S/N 47727N68280Frint Michael R · Elk Grove, CABuilt 1978 · S/N 15282226N6828ESheppard Walter S · Troy, IDBuilt 1959 · S/N 56328
Back to AD 87-20-03 R2