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.

N5645AAll Seasons Catering Inc · Shelter Isl, NYBuilt 1956 · S/N 28245N5645BHenderson William R · Ohatchee, ALBuilt 1956 · S/N 33645N5645RGecha Brian S · Brandon, VTBuilt 1965 · S/N 17253270N5645TJ & J Aviation Inc · Martinsville, VABuilt 1964 · S/N 17251545N5646AHeffron Jacob L · Little Falls, MNS/N 28246N5646BSkydive Ky LLC · Cecilia, KYS/N 33646N5646RAumack Bryant D · Melbourne, FLBuilt 1965 · S/N 17253272N5647GDarter Lloyd R · Mountain Grove, MOBuilt 1973 · S/N 18801129N5647TJohnson Jeffri K · Brighton, COBuilt 1964 · S/N 17251547N5648AMartin Rand E · Lake Stevens, WAS/N 28248N5648BBailey Carl · Huntington, WVBuilt 1956 · S/N 33648N5648JSswb Enterprises LLC · Lufkin, TXBuilt 1974 · S/N 18263479N5648RKurtz Richard G · Ithaca, NYS/N 17253275N5648TYankton Area Aviators Inc · Crofton, NEBuilt 1964 · S/N 17251548N5649AMinor Charles G · Medford, ORS/N 28249N5649GMaran Properties LLC · Lowell, ARBuilt 1979 · S/N 17273564N564CMurray Robert G · Eudora, KSBuilt 1964 · S/N 185-0656N564DSLopez John · Prole, IAS/N 15066564N564EDTilse William A · Kirkland, WABuilt 1956 · S/N 28362N564GHughes Ramzi S · Alamo, NVBuilt 1968 · S/N 15068276N564MML A M Capital Management LLC · Sheridan, WYBuilt 1982 · S/N 17275714N564QLSimcic Kathryn C · Grain Valley, MOBuilt 1969 · S/N 15070570N564RRAlpha Romeo Aviation LLC · Newark, DEBuilt 1982 · S/N T30300136N5650BPlane Life LLC · Wilmington, DEBuilt 1956 · S/N 33650N5650TWander Harry J · Nevada City, CABuilt 1964 · S/N 17251550N56511Wired Flight LLC · Kent, WABuilt 1974 · S/N 18502525N5651RChickasha Wings Inc · Chickasha, OKBuilt 1965 · S/N 17253279N5651TRegistered aircraftS/N 17251551N5652APatriot Aviation · Loomis, CABuilt 1956 · S/N 28252N5652ECgumps LLC · Antioch, TNBuilt 1978 · S/N 17271912N5653BKey Jon · Seminole, TXFirst renewal noticeBuilt 1956 · S/N 33653N5653GCavanaugh Joseph Rex · Alvin, TXBuilt 1969 · S/N 15071153N5654GNorman Charles E · Zanesville, OHBuilt 1969 · S/N 15071154N5654RSudbrink Charles D · Willet, NYS/N 17253283N5654THayes Travis · Harrisonville, MOS/N 17251554N5655GAnderson Kevin G · Pleasant Hill, CABuilt 1969 · S/N 15071155N5656EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271913N5656GLet There Be Flight LLC · Portage, MIBuilt 1969 · S/N 15071156N5657RFord Darryl · Caldwell, IDBuilt 1965 · S/N 17253287N56581United States Department Of Interior · Boise, IDBuilt 1975 · S/N 18502907N5658AEwartsville Flyers LLC · Pullman, WABuilt 1956 · S/N 28258N5658BSheyman Igor · Danville, CAS/N 33658N5658REilers Scott D · Amissville, VABuilt 1965 · S/N 17253289N5659AChaouki Rebecca · La Crosse, WIBuilt 1957 · S/N 28259N5659BAom Aircraft LLC · Wilmington, DEBuilt 1956 · S/N 33659N5659GLacy Melodi J · Swanton, VTBuilt 1969 · S/N 15071159N5659JGilbert Duane A · Reno, NVBuilt 1974 · S/N 18263481N5659TMorgan Peter Thomas · Bellingham, WABuilt 1964 · S/N 17251559N565CMBackcountry Aviation LLC · North Salt Lake, UTBuilt 1968 · S/N U2061044N565KGGilley Jerry · Maryville, TNBuilt 1973 · S/N 18261775
Back to AD 87-20-03 R2