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.

N694MDBice Eric L · Renton, WABuilt 1959 · S/N 50694N694MMBrown Ryan W · Nampa, IDBuilt 1969 · S/N 18259874N694QPhillips Todd · New Albany, MSBuilt 1963 · S/N 18254585N6950AGallagher David R · Auburndale, FLBuilt 1956 · S/N 29050N6950EMahler Jacson B · Reno, NVS/N 56450N6950FRgv Flight Academy LLC · Bayview, TXBuilt 1966 · S/N 15063550N6950XAnderson Thomas R · Seattle, WABuilt 1960 · S/N 17247850N6951GHernandez Alfonso · Garland, TXBuilt 1970 · S/N 15072451N6951MDavid Paul T · Santa Barbara, CABuilt 1975 · S/N 18263896N6951YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N P210-00380N6952ABig Sky Adventures LLC · Nicholasville, KYBuilt 1956 · S/N 29052N6952EBeauchamp James W · Butte, MTBuilt 1959 · S/N 56452N6952FSkalsky Nathan · Tigard, ORBuilt 1966 · S/N 15063552N6952HIronfield Jeffrey A · Livermore, CABuilt 1981 · S/N 18267898N6952SMyers Karen J · Bemidji, MNBuilt 1967 · S/N 15067652N6953GVidal Miguel · Novi, MIS/N 15072453N6953MN6953m Kemt Aircraft LLC · Monrovia, CABuilt 1975 · S/N 18263898N6954ALindroth Richard J · Eleanor, WVBuilt 1956 · S/N 29054N6954EBaylis Thomas B · Hattiesburg, MSS/N 56454N6954FRegistration Pending · Sumner, WARegistration pendingBuilt 1966 · S/N 15063554N6954SPierson Jared · Coeur D Alene, IDBuilt 1967 · S/N 15067654N6954XSebestik William C · Walker, MNS/N 17247854N6955AFortman James · Vancouver, WABuilt 1956 · S/N 29055N6955EGopalakrishna Prahlad Menon · Gibsonia, PABuilt 1959 · S/N 56455N6955GExecutive Aircraft International Inc · Bolivar, TNS/N 15072455N6955NSweet Fred A · Loves Park, ILBuilt 1981 · S/N 18504315N6955SHhd Aviation LLC · Hamilton, OHBuilt 1967 · S/N 15067655N6955VNeu Timothy F · Orlando, FLBuilt 1965 · S/N 18256630N6955XDirigo Aerospace Solutions LLC · Sumner, MEBuilt 1960 · S/N 17247855N6956AChristensen Curtis A · Lincoln, NEBuilt 1956 · S/N 29056N6956EMetzger Greg · Clovis, CABuilt 1959 · S/N 56456N6956GR & B Helicopters Inc · Calhoun, GABuilt 1970 · S/N 15072456N6957FRussell Clyde R Jr DBA · Montrose, ARS/N 15063557N6958EAnderson Glenn Merrell · Duluth, MNBuilt 1959 · S/N 56458N6958GScoskie Keith E · Van, TXBuilt 1970 · S/N 15072458N6958HJewell Aviation Inc · Kennett, MOBuilt 1975 · S/N 17265663N6958SPeterson Leonard J · Cleveland, TNBuilt 1967 · S/N 15067658N695XCloud 9 Aviation LLC · Bismarck, NDBuilt 1980 · S/N R18201592N6960FFirst Waypoint LLC · Mckinney, TXS/N 15063560N6960HZiller Wayne Jr · Fairbury, ILBuilt 1975 · S/N 17265664N6961ABontadellis Flying Service Ll · Polson, MTBuilt 1956 · S/N 29061N6961XHays Christopher Keith · Cleveland, MSS/N 17247861N6962ARogakis Christopher M · Spring Hill, KSBuilt 1956 · S/N 29062N6962FSiegrist Gary D · Belvidere, ILS/N 15063562N6962GGill Robert S · Anchorage, AKBuilt 1970 · S/N 15072462N6962MAbramson Jerrold B Trustee · Simi Valley, CABuilt 1975 · S/N 18263901N6962XBradsher Harold M · Troy, MOBuilt 1960 · S/N 17247862N6963AFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1956 · S/N 29063N6963MHathaway Virgil F · Spokane, WABuilt 1975 · S/N 18263902N6964AJackalope Aviation LLC · Bellingham, WAS/N 29064
Back to AD 87-20-03 R2