OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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.

N501DSChilson Jacob Shane · Willits, CABuilt 1966 · S/N 18257193N501GEPhillips Matthew D · Astoria, ORS/N 18257106N501MPManzoor Khan · Stockton, CABuilt 1978 · S/N 17270318N501NGCummings Johnny R IV · Clearwater, FLBuilt 1970 · S/N 18260486N501PAChapman Anthony J · Henderson, NVBuilt 1975 · S/N 15077482N501SFNomarco Inc · Woodburn, ORS/N 21061808N501TSFlying Tigers Flight School LLC · Houston, TXBuilt 1976 · S/N 17266839N501WAFerrari Jason M · Medina, OHBuilt 1975 · S/N 15076640N50201Ahrens Brian T · Hainesport, NJBuilt 1968 · S/N 15069131N50202Velasquez Jorge · Brawley, CABuilt 1968 · S/N 15069132N50205Spruce Moose LLC · Salt Lake City, UTS/N 15069135N50208Haus Jesse M · Fort Worth, TXBuilt 1974 · S/N 17264197N50209N Maple LLC · Kalispell, MTBuilt 1968 · S/N 15069139N5020DSpiro Paul M · Anchorage, AKBuilt 1958 · S/N 51120N5020HBorreson Anthony · Mariposa, CABuilt 1975 · S/N 17265303N5020RMigliaccio Jason · Palm Bay, FLBuilt 1974 · S/N 17263261N50213Canarr Randall J · Anchorage, AKS/N 15069141N50219Sftb LLC · Miami, FLBuilt 1968 · S/N 15069145N5021HAlamo Flyers LLC · Elmendorf, TXBuilt 1975 · S/N 17265304N5021RWax Sally G · Louisville, KYBuilt 1974 · S/N 17263262N50221Smith Wayne A · Uxbridge, MABuilt 1968 · S/N 15069146N50222Baldwin Kevin R · San Tan Valley, AZBuilt 1968 · S/N 15069147N50224Reshetar Ryan D · Evansville, INBuilt 1968 · S/N 15069149N5022DSearey 806 LLC · Weirsdale, FLBuilt 1958 · S/N 51122N50231Aaronflight LLC · Hillsboro, ORBuilt 1968 · S/N 15069153N50232Firby John E · Diamond, OHBuilt 1968 · S/N 15069154N50233Garofalo Dawn L · Bellingham, WABuilt 1972 · S/N U20601911N50234Lloyd Barry C · Sacramento, CABuilt 1968 · S/N 15069156N5023EHarned William C · Lebanon Junction, KYBuilt 1958 · S/N 50323N5023RStern Joseph L · Morrow, OHBuilt 1974 · S/N 17263264N50245Christian Martha J · Ham Lake, MNBuilt 1968 · S/N 15069163N5024ADucharme Matthew B · Harlem, GABuilt 1955 · S/N 28024N5024DGordon Glen M · Corning, CABuilt 1958 · S/N 51124N50251Featherston Nicholas L · Chandler, AZBuilt 1968 · S/N 15069167N50252Price Benjamin A · Hattiesburg, MSBuilt 1968 · S/N 15069168N50255Andrews Michael E · Huron, OHBuilt 1968 · S/N 15069170N50258Willis Walter W · Kamiah, IDS/N 15069172N50261Copeland Joey A · Douglas, GABuilt 1968 · S/N 15069174N50262Garrison Vincent Gray · Yadkinville, NCBuilt 1968 · S/N 15069175N50263Registered aircraftBuilt 1968 · S/N 15069176N50266Plentl Steve R · Shepherd, TXBuilt 1968 · S/N 15069179N50267Buckner Natasha · Locust Grove, VABuilt 1968 · S/N 15069180N50268Mach Steven William · Chicago, ILBuilt 1968 · S/N 15069181N50269Joerger Dannie L · Greensburg, INBuilt 1968 · S/N 15069182N5026DRoss George W · Boise, IDS/N 51126N5026RSwinney Marty Sherman Trustee · Macomb, OKBuilt 1974 · S/N 17263267N5026UBorders Nowell Equipment G P Inc · Edinburg, TXBuilt 1963 · S/N 206-0026N5026VPiland Kenneth Eldon Jr · Carlsbad, CABuilt 1975 · S/N 21060822N50270Flanagan Elizabeth M · Coronado, CABuilt 1968 · S/N 15069183N50274Currie William O · Lumberton, NCBuilt 1968 · S/N 15069186
Back to AD 87-20-03 R2