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.

N63169Spinola Hernandes M · Homestead, FLBuilt 1975 · S/N 15077153N6316BSouthwinds Export Inc · Kissimmee, FLS/N 15283918N6316DRuiz Edinson · Bakersfield, CABuilt 1979 · S/N 17272714N6316GChurch Aviation LLC · Christmas Valley, ORFirst renewal noticeS/N 15071816N6316SGlobal Navigator LLC · Anacortes, WABuilt 1967 · S/N 15067116N63174Evans James II · Seattle, WAS/N 17275399N63179Fetch Carl Jr · Monongahela, PABuilt 1975 · S/N 15077157N6317DJkg LLC · Murfreesboro, TNBuilt 1979 · S/N 17272715N6317QSouthwinds Export Inc · Kissimmee, FLS/N 15285230N6317TShaffer Dyke T · Santa Rosa, CABuilt 1984 · S/N R18201975N63180Hall Thomas E · Sylvia, KSBuilt 1975 · S/N 15077158N63181Wild Blue Flight LLC · Ellensburg, WABuilt 1975 · S/N 15077159N63186Branche Mitchell J · Winter Haven, FLBuilt 1975 · S/N 15077164N6318AElliott Dave P · Boulder, COBuilt 1956 · S/N 33118N6318BCenturion Associates 2 LLC · Elgin, SCBuilt 1978 · S/N 21062745N6318EEvans Robert W · Upland, CABuilt 1959 · S/N 46418N6318TPollock John · Cleburne, TXBuilt 1984 · S/N R18201976N63197Deangelis Kristopher M · Las Vegas, NVBuilt 1975 · S/N 15077166N63198White Hayden · Lees Summit, MOBuilt 1975 · S/N 15077167N63199Winfred & Waters LLC · Georgetown, TXBuilt 1975 · S/N 15077168N6319BAtarah LLC · Tucson, AZBuilt 1957 · S/N 34219N6319FAbidance Inc · Winthrop, WAS/N 18264154N6319KStemmer Kenneth Edward · Palm Desert, CABuilt 1975 · S/N 15077641N6319TSunland Aviation LLC · Swansboro, NCBuilt 1984 · S/N R18201977N631EHHuddleston Edward L · Oaktown, INBuilt 1966 · S/N 15063361N631PAPetaluma Pilot Training Center · Petaluma, CABuilt 1977 · S/N 15280835N631SLee Grant L · Dallas, TXBuilt 1977 · S/N 18265554N63205Bagwell Robert B · Sequim, WABuilt 1975 · S/N 15077173N63207Two Star Maritime LLC · Fremont, CABuilt 1975 · S/N 15077175N6320FJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1979 · S/N 17273190N6320GBurks Michael S · Shoshone, IDBuilt 1970 · S/N 15071820N6320HWaypoint Corp · Clearwater, FLS/N 18267883N6320PSims Jacob Trustee · Montrose, COBuilt 1978 · S/N P21000168N6320RGehr Garner J · Eustis, FLS/N 172RG0163N63210Johnson Mark L · Bend, ORBuilt 1975 · S/N 15077177N63211Prestige Worldwide Charters LLC · Edgartown, MABuilt 1975 · S/N 15077178N63214Brady William Berte · Venice, FLS/N 15077181N63219Cresap Dale A · Idaho Falls, IDS/N 15077185N6321FSolar Repair Center Inc · Beaumont, CABuilt 1975 · S/N 18264156N6321GFurlong Kelly · Athens, ALBuilt 1970 · S/N 15071821N6321HBluebird Inn Inc · Fish Haven, IDBuilt 1981 · S/N 18267884N6321KBrookby John M · Grand Prairie, TXBuilt 1975 · S/N 15077642N6321MCalifornia In Nice Inc · San Jose, CABuilt 1980 · S/N 15284671N6321PXin Han Aviation LLC · Atwater, CABuilt 1981 · S/N 15284999N6321SStoker Dana R Trustee · Tucson, AZBuilt 1967 · S/N 15067121N6321TTwo One Tango LLC · Waynesboro, PABuilt 1984 · S/N R18201978N63220Ronchini Denis · Haverhill, MABuilt 1975 · S/N 15077186N63221Ruebush Joshua K · Eaton, OHBuilt 1975 · S/N 15077187N6322FKamp LLC · Kalispell, MTBuilt 1975 · S/N 18264157N63231Stafford Anthony T · Collierville, TNS/N 15077189
Back to AD 87-20-03 R2