OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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.

N18634Bagge William J · East Longmeadow, MABuilt 1972 · S/N 15074004N18637Vincent Addison J · Waynesburg, OHBuilt 1972 · S/N 15074006N1863CWalch Brian A · Anchorage, AKBuilt 1953 · S/N 26007N1863FAndersen Dana K · Scappoose, ORS/N 21058763N1863QCollins David A · Portland, ORBuilt 1972 · S/N 177RG0263N18640Smith David W · Elgin, SCBuilt 1972 · S/N 15074008N18643Registered aircraftN-number assigned, not yet registeredS/N 17702545N18645Sorenson Mark A · Senoia, GAS/N 15074011N18649Dixon Robert D · Derry, PABuilt 1972 · S/N 15074015N1864CRegistered aircraftBuilt 1953 · S/N 26008N1864FSwensen Nathan E · Winnemucca, NVS/N 21058764N1864VFrost Dennis J · Appleton, WIBuilt 1974 · S/N 17263774N1864YHeckendorf Jon W · Ordway, COBuilt 1962 · S/N 17249464N18656Larsen Steve · Colton, ORBuilt 1972 · S/N 15074019N1865XAria & Arjun LLC · Cumming, GABuilt 1964 · S/N 18255965N1865ZBpf Equipment LLC · Burnet, TXBuilt 1962 · S/N 205-0065N18663Van Dyke John · Hopkins, MIBuilt 1973 · S/N 15074025N1866QPez Air LLC · Cleveland Heights, OHBuilt 1972 · S/N 177RG0266N18674Vandervegt Nathan J · Juneau, AKBuilt 1972 · S/N 15074034N18678Laviolette Stephen O · Dallas, TXBuilt 1972 · S/N 15074037N1867FIcarus Aviators LLC · Canon City, COBuilt 1966 · S/N 21058767N1867XWaypoint208 LLC · Chubbuck, IDBuilt 1964 · S/N 18255967N18686Duvoisin Tom Jr · Powell, TNBuilt 1972 · S/N 15074041N1868VCreative Strategies Inc · Proctorville, OHBuilt 1974 · S/N 17263775N1868ZZulu Forty One LLC · Anchorage, AKBuilt 1962 · S/N 205-0068N18694Hughes Randall L · Post Falls, IDBuilt 1976 · S/N 17702547N18697Cannon Corey D · Elk Grove, CABuilt 1972 · S/N 15074049N18698Lumpkin Larry T · Ocala, FLBuilt 1969 · S/N 18052076N1869CSale Reported · Gorham, MESale reportedBuilt 1953 · S/N 26013N1869FRegistration Pending · Dublin, OHRegistration pendingBuilt 1966 · S/N 21058769N1869XFlying Yankees Inc · Nashua, NHBuilt 1964 · S/N 18255969N1869ZPinnell Bradley T · Lake Havasu City, AZBuilt 1962 · S/N 205-0069N186ARAircraft Holdings LLC · Morgantown, WVS/N 15077554N186AZIz Air LLC · Miami, FLBuilt 1976 · S/N 18503192N186CTRegistered aircraftBuilt 1961 · S/N 18050978N186DMann Thomas A · Ford, WABuilt 1961 · S/N 185-0127N186FMJett Aviation LLC · Clovis, NMFirst renewal noticeBuilt 1977 · S/N 17269339N186MLIdaho Fly Girl LLC · Boise, IDBuilt 1974 · S/N U20602644N186RDWayson Air LLC · Mount Auburn, IABuilt 1966 · S/N 21058761N186RMAdkins Robert P · Eagle River, AKBuilt 1958 · S/N 51603N186RWBlake Robert · Gold Creek, MTS/N 18052624N186RZRex Zollinger Aviation LLC · Woods Cross, UTBuilt 1969 · S/N 18259557N186VAplikowski Aviation LLC · Lino Lakes, MNBuilt 1969 · S/N 185-1511N186XHaldeman Hangars LLC · Vancouver, WABuilt 1962 · S/N 1850437N187Molina Luis J · Broken Arrow, OKBuilt 1975 · S/N P3370208N1870FWilliams Aviation LLC · Indianola, IAS/N 21058770N1870QTrebilco David R · Cedar Park, TXBuilt 1972 · S/N 177RG0270N1870VSanders-Smith Kimberly K · Napa, CABuilt 1974 · S/N 17263776N1870ZZerkel Kirk Zachary · Wasilla, AKBuilt 1962 · S/N 205-0070N18716Gem LLC · San Clemente, CABuilt 1972 · S/N 15074056
Back to AD 87-20-03 R2