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.

N6075FSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 18264090N6075GTango Aviation Rentals LLC · Austin, TXBuilt 1969 · S/N 15071575N6075JLowrance Kathleen C · Plano, TXBuilt 1972 · S/N A1500375N6075KWilliams Todd D · Perry, UTBuilt 1976 · S/N R1722025N6075RNelsn Hans A · Sergeant Bluff, IABuilt 1965 · S/N 17253744N60761Code 1 Flight Training LLC · Canton, TXS/N 15070556N60766Congdon Douglas J · Fairbanks, AKBuilt 1973 · S/N U20602044N60767Turnier Mikel W · Middletown, NYBuilt 1969 · S/N 15070561N60768Mcgee Jacob Quinton · Anchorage, AKS/N U20602045N60769Del Duca Frank J · Bethel, MEBuilt 1969 · S/N 15070563N6076ABack Daryl · Stephenville, TXBuilt 1956 · S/N 28676N6076BBouchard Timothy · Valdez, AKBuilt 1957 · S/N 34076N6076FCancro J Chriss · Enumclaw, WABuilt 1975 · S/N 18264091N6076GColbert Farms Inc · Davenport, WAS/N 15071576N6076RAdvanced Targeting Solutions LLC · Perkasie, PABuilt 1965 · S/N 17253745N60773Edwards Air LLC DBA · Raleigh, NCBuilt 1969 · S/N 15070566N6077AHall James E III · Lumber Bridge, NCBuilt 1956 · S/N 28677N6077JLove To Fly LLC · Myrtle Beach, SCBuilt 1975 · S/N 18263627N6077KRocha Adrian M · Rosharon, TXBuilt 1975 · S/N 15077513N6077RCultra Daniel L · Rochelle, ILS/N 17253746N60781Two Birds One Bear LLC · Upper Arlington, OHBuilt 1969 · S/N 15070574N60787Kenses Daniel T · Stuart, FLBuilt 1969 · S/N 15070579N6078ASnell Jeffrey D · Inver Grove Hghts, MNBuilt 1956 · S/N 28678N6078CKtoa Rentals LLC · Torrance, CABuilt 1978 · S/N R18200370N6078ROancea Traian · Oakdale, CABuilt 1965 · S/N 17253747N60790Jenkins Berry E · Bell, FLBuilt 1969 · S/N 15070581N60793Registered aircraftBuilt 1969 · S/N 15070584N60796Lemanski Thomas A · Port Townsend, WABuilt 1969 · S/N 15070585N60797Portland Metro Aviation & Flying Club · Portland, ORBuilt 1969 · S/N 15070586N60798Hjl Farm Inc · Dagmar, MTS/N 15070587N6079ARegistration Pending · Hartford, SDRegistration pendingBuilt 1956 · S/N 28679N6079BRift LLC · Union, MOBuilt 1957 · S/N 34079N6079CAllen William H Trustee · Big Bear City, CAS/N R18200371N6079F6079 Foxtrot Inc · Dover, DES/N 18264094N6079JSmith Richard D II · Luthersville, GAS/N A1500379N6079TFookes Raymond R · Lenoir City, TNS/N 15060779N60800Edens Harald E · Socorro, NMBuilt 1969 · S/N 15070588N60802Smith Jay · San Andreas, CAS/N 15070590N60808Foster William L · Waco, TXS/N 15070592N6080FKonecny Walter O · Draper, UTS/N 18264095N6080JRidgewood Corp Inc · Orangeville, PAFirst renewal noticeS/N A1500380N60818Bailey James C · Drummond Island, MIBuilt 1969 · S/N 15070597N6081ABoykin Bobby · Brandon, MSS/N 28681N6081CShannon Jeanette M · Marathon, FLS/N R18200372N6081RWatler John L · Brazil, INBuilt 1965 · S/N 17253750N60822Hawkinson Paul M · Grand Rapids, MNS/N 15070600N60825Namtvedt Erik L · Wasilla, AKBuilt 1969 · S/N 15070603N6082KCarlton David L · Galesburg, ILBuilt 1975 · S/N 15077516N60830Ace Aviation Seminars LLC · Armuchee, GABuilt 1969 · S/N 15070606N60831Itm Aircraft LLC · North Charleston, SCBuilt 1969 · S/N 15070607
Back to AD 87-20-03 R2