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.

N1881CAmaryllis Living LLC · Tampa, FLS/N 26025N1881MBrutlag Farms Inc · Wendell, MNBuilt 1973 · S/N 33701481N1881YSutton Aircraft Salvage LLC · Palmer, AKBuilt 1962 · S/N 17249481N1882XWagner Robert W · Casper, WYBuilt 1965 · S/N 18255982N1882YDunlap Alexander W · Eads, TNS/N 17249482N1882ZConstable William H · Rch Palos Vrd, CABuilt 1962 · S/N 205-0082N1883FAnkeney Scott · Canyon, TXBuilt 1966 · S/N 21058783N1883QMitchell Philip J · Arlington, TXS/N 177RG0283N1884VMurphy Edward L · Fairmont, WVBuilt 1974 · S/N 17263781N1884XKaines John L · Ludington, MIBuilt 1965 · S/N 18255984N1885CZibell David H · Olympia, WABuilt 1953 · S/N 26029N1885MLittle Dog Aviation LLC · Anchorage, AKBuilt 1975 · S/N 18264468N1885QHansen Peter J · New Iberia, LABuilt 1972 · S/N 177RG0285N1886VAngelone Inc · Elkhart, INBuilt 1974 · S/N 17263782N1887CRiggs Eugene D · Shoreline, WAS/N 26031N1887FHeadings Kevin · Echo, ORS/N 21058787N1887QLosyad LLC · Sanford, FLBuilt 1972 · S/N 177RG0287N1887ZDavidson David R · Sutton, AKS/N 205-0087N1888CWayman Ian A · Peyton, COBuilt 1953 · S/N 26032N1888QAmerican Aerial Photos LLC · Efland, NCBuilt 1972 · S/N 177RG0288N1889CKlindworth Bo N · Beulah, NDBuilt 1953 · S/N 26033N1889FPiper Henry Burton Jr · Kingston, TNBuilt 1966 · S/N 21058789N1889QRuff Randall N · Bay City, MIBuilt 1972 · S/N 177RG0289N1889VCroome James Earl Jr · Sandersville, GABuilt 1974 · S/N 17263783N188CRempfer David Dwayne · Chandler, AZS/N 27104N188HS&T Aviation LLC · Santa Teresa, NMS/N 50652N188HTReady Aim Flyer LLC · New Castle, DEBuilt 1979 · S/N T18803430TN188PLe Duc Richard Steven · Mazama, WABuilt 1963 · S/N P17257122N189Jones William Cody · Roxton, TXS/N P3370209N1890MPutney Bruce N · Midlothian, TXS/N 33701490N1890ZAlaniz Jose M · Yreka, CABuilt 1962 · S/N 205-0090N1891CCoetzee Theo · San Luis Obispo, CABuilt 1953 · S/N 26035N1891MStarkman Timothy S · Monterey, CABuilt 1975 · S/N 18264470N1891YCarolina Sky LLC · Rock Hill, SCBuilt 1962 · S/N 17249491N1892FPanagotacos George · Corona, CABuilt 1966 · S/N 21058792N1892VSmith Air Inc · Ukiah, CABuilt 1974 · S/N 17263784N1892XCuvar Philip M · Granite City, ILBuilt 1965 · S/N 18255992N1892YBaker David Laurence · Nelson, WIS/N 17249492N1893CFife Christopher R · Winslow, MEBuilt 1953 · S/N 26037N1893FKleeman Mark · Kearney, MOFirst renewal noticeS/N 21058793N1893QSauk Prairie Aviators LLC · Merrimac, WIBuilt 1972 · S/N 177RG0293N1893YWhelan John J · Mount Vision, NYBuilt 1962 · S/N 17249493N1894XCorso Aviation LLC · Southlake, TXBuilt 1964 · S/N 18255994N1894ZEverly Peter · Fort Smith, ARBuilt 1962 · S/N 205-0094N1896CGladish Jeffrey · Terrell, TXBuilt 1953 · S/N 26041N1896XSmr Holdings LLC · Martinsburg, WVBuilt 1964 · S/N 18255996N1896YArmond Richard Joseph · Thousand Oaks, CABuilt 1962 · S/N 17249496N1897CBentley Eric T · Farmersville, TXBuilt 1953 · S/N 26042N1897QGuadarrama Joe R · Vacaville, CABuilt 1972 · S/N 177RG0297N1897VBarxbar Aviation LLC · Mesa, AZBuilt 1974 · S/N 17263785
Back to AD 87-20-03 R2