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.

N5544TPercario Joseph · Warren, NJBuilt 1982 · S/N R18201893N55457Legend Air Lease LLC · Hurricane, UTBuilt 1981 · S/N 17275184N5545AWhelan Peter A · Kettering, OHBuilt 1985 · S/N P21000864N5545CJenkins Alfred G · Bangor, MEBuilt 1950 · S/N 19598N5545GTinkham Dennis T · Leavenworth, KSBuilt 1969 · S/N 15071045N5545RCarlson Michael · Burlington, WYBuilt 1965 · S/N 17253130N5545SLareve Air LLC · Bloomfield, MIBuilt 1980 · S/N R18201604N5545TMoody Bible Institute Of Chicago · Spokane, WABuilt 1982 · S/N R18201894N5546BHeczko Eric M · Longmont, COBuilt 1956 · S/N 33546N5546CWeinant Michael W Trustee · Fairbanks, AKBuilt 1950 · S/N 19599N5546HMoore Thomas P · Basalt, COBuilt 1981 · S/N 18267873N5546JRegistration Pending · Danbury, CTRegistration pendingS/N 17273816N5546RGorn Joel · Lawrence, MABuilt 1979 · S/N 172RG0075N5546SChoice Vc LLC · Oakland, MIBuilt 1980 · S/N R18201605N5546TMeigs Craig · Jasper, ALS/N 17251446N5547TGoodyear Ron L · Leo, INBuilt 1964 · S/N 17251447N5547VDahl Demar · Deeth, NVS/N 32054N55482Crook Mark E · Elberton, GABuilt 1981 · S/N 17275193N5548LUnruly Passengers LLC · Piedmont, SCBuilt 1980 · S/N 15284350N5548RSmietanski Nathan E · Terlton, OKBuilt 1965 · S/N 17253134N5548SGardner Timothy J · Gardnerville, NVS/N R18201606N5549AGeoterra Inc · Eugene, ORBuilt 1979 · S/N 21063491N5549GFrantz Donna Pratt · Ocala, FLBuilt 1969 · S/N 15071049N5549NRfd Aero LLC · Wilsonville, ORBuilt 1980 · S/N 18267784N5549SArdizzone Mark Robert · Mckinney, TXS/N R18201607N554CTGeyer Martin J · Caro, MIBuilt 1975 · S/N 18263737N5550BLieberherr John W · Clancy, MTS/N 33550N5550CBendickson Roger · Garrison, NDBuilt 1950 · S/N 19603N5550JOptima Aviation LLC DBA · Lewisville, TXBuilt 1980 · S/N 17273818N5550RMetro Technology Centers · Oklahoma City, OKBuilt 1965 · S/N 17253137N5550TCirrus Five LLC · Merritt, NCBuilt 1964 · S/N 17251450N5550YSteiner Paul R · Boerne, TXBuilt 1981 · S/N 21064245N55515Fly Cessna LLC · Peoria, AZBuilt 1981 · S/N 17275195N5551CAer Kelly LLC · Port Orange, FLBuilt 1950 · S/N 19604N5551LPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 15284353N5551TBailey Robert S · Temecula, CAS/N 17251451N55521Carter Flygare Inc · Sacramento, CABuilt 1981 · S/N 17275196N5552CMcqueary David L · Plant City, FLBuilt 1950 · S/N 19605N5552EAbove And Beyond Aviation LLC · Austin, TXS/N 17271887N5552MRegistration Pending · Fayetteville, TNRegistration pendingBuilt 1980 · S/N 15284613N5552VJust Plane Stuff Inc · Jackson, MSBuilt 1980 · S/N 172RG0570N5553EVogel Mark · North Bethesda, MDBuilt 1983 · S/N 18268331N5553TVan Kleek Steve D · Milford, IABuilt 1964 · S/N 17251453N5554RRidge Rickey S · Wortham, TXBuilt 1965 · S/N 17253142N5554TBmtc Aircraft LLC · Salem, ORS/N 17251454N5555BGonzales Gerson · San Juan, PRBuilt 1956 · S/N 33555N5555CRestel Gregory S · Savannah, GABuilt 1950 · S/N 19608N5555GSinton Frank J · Durango, COBuilt 1975 · S/N 21061039N5555SSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N P21000417N5556RWbs 1 LLC · Huron, SDBuilt 1965 · S/N 17253145
Back to AD 87-20-03 R2