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.

N3636UVandeman Jack P · Norco, CABuilt 1963 · S/N 18255036N3636YMorales Peter · Lake Worth, FLBuilt 1963 · S/N 21058136N3637CThree Seven Charlie LLC · Camp Hill, PABuilt 1978 · S/N R18200288N3638JEngelskirger Karl D · Valley City, OHBuilt 1966 · S/N 15064938N3638VHope Virginia L · Georgetown, OHS/N 15076571N3639JPrima County Community College · Tucson, AZBuilt 1966 · S/N 15064939N3639LAzimuth Partners II LLC · Sanford, FLBuilt 1965 · S/N 17253808N3639UWaltz Elizabeth · Grapevine, TXBuilt 1963 · S/N 18255039N3639YMurphys Flying Service LLC · Quitman, GABuilt 1963 · S/N 21058139N363JVRead Andrew R · Milwaukee, WIBuilt 1976 · S/N 18502991N364Farmers Bank · Parsons, TNBuilt 1976 · S/N P3370243N3640JCovington Brian · Florence, ALBuilt 1966 · S/N 15064940N3640LHussain Mahmoud T · Miami, FLBuilt 1965 · S/N 17253809N3640SPetersen Jacob R · Wasilla, AKS/N 17250840N3640UMarkle Raymond J · Madawaska, MEBuilt 1963 · S/N 18255040N3641CFeldmann D Joshua · Epworth, IABuilt 1978 · S/N R18200290N3641LSeaplanes R Fun Inc · Wilmington, DEBuilt 1965 · S/N 17253810N3641VWright John C · Windham, MEBuilt 1975 · S/N 15076573N3642CMcmahan Bryan · Gakona, AKBuilt 1954 · S/N 31140N3642LMetro Technology Centers · Oklahoma City, OKBuilt 1965 · S/N 17253811N3642UPm Barrett Aviation LLC · Tucson, AZBuilt 1963 · S/N 18255042N3643BCoffelt Kelly L · Bend, ORBuilt 1956 · S/N 32347N3643CThompson Thomas S · Stoutsville, OHS/N 31141N3643SMaycroft David · Cary, ILBuilt 1963 · S/N 17250843N3643UN3643u Aviation LLC · Denver, COBuilt 1963 · S/N 18255043N3644JBoggs Dilan · Nicholls, GABuilt 1966 · S/N 15064944N3644LHobbie Roy Lee · Cynthiana, KYBuilt 1965 · S/N 17253813N3644SMurray William · East Jordan, MIBuilt 1963 · S/N 17250844N3644TArizona Air Salvage · Phoenix, AZS/N 17260849N3644ULawrence Carl E · Boulder, COBuilt 1963 · S/N 18255044N3645LRegistered aircraftBuilt 1965 · S/N 17253814N3645UHusaim John Steven · Hohenwald, TNBuilt 1963 · S/N 18255045N3646JRegistration Pending · Cornelius, NCRegistration pending, pending cancellationBuilt 1966 · S/N 15064946N3646LRobert Roger J · Gardner, MABuilt 1965 · S/N 17253815N3646SCummings Larry D · Clarence, NYBuilt 1966 · S/N 17254827N3646UGarner Lynn · Preston, IDS/N 18255046N3646YAerohawk Aviation Inc · Idaho Falls, IDBuilt 1963 · S/N 21058146N3647CSmith Kristopher D · Wickenburg, AZBuilt 1954 · S/N 31145N3647LEmmett Kerry N · Greeneville, TNBuilt 1965 · S/N 17253816N3647UAdams Verne Franklin · Madera, CABuilt 1963 · S/N 18255047N3648LGlenn William · Marion, NCBuilt 1965 · S/N 17253817N3648UMerlin Aviation LLC · Grants Pass, ORBuilt 1963 · S/N 18255048N3649CBayou Flight LLC · Parker, COBuilt 1954 · S/N 31147N3649LArmour Walton H · Alliance, OHBuilt 1965 · S/N 17253818N3649USteele Aerospace Service LLC · Tulsa, OKS/N 18255049N364CMoore Charles K · Woodinville, WABuilt 1978 · S/N 18266262N364CKSchneider William J Jr · Cedar Key, FLS/N 17260354N364GSpruce Creek Consultants LLC · Port Orange, FLBuilt 1972 · S/N 17701776N364MGCw Aviation LLC · Washta, IABuilt 1979 · S/N R18201246N364SRSales Joe H DBA · Seminole, TXBuilt 1964 · S/N 17251558
Back to AD 87-20-03 R2