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.

N7205QN7205q LLC · Titusville, FLBuilt 1972 · S/N 17260505N7205SRegistration Pending · Dillingham, AKRegistration pendingBuilt 1967 · S/N 15067905N7206ABerle William M · White Hills, AZS/N 29306N7206GKane Gabriel · Yucaipa, CABuilt 1973 · S/N 15074622N7206QN7206q LLC · Myrtle Beach, SCBuilt 1972 · S/N 17260506N7206TSimmons William E · Port Orchard, WABuilt 1959 · S/N 46806N7206XChickasha Wings Inc · Chickasha, OKS/N 15059306N7207GCowden Flying Services Inc · Fort Worth, TXBuilt 1969 · S/N 17258907N7207NRuper Chad A · Horseheads, NYBuilt 1974 · S/N 18262999N7207QMountain Peaks Aviation LLC · Clancy, MTBuilt 1972 · S/N 17260507N7207SRademacher Kenneth J · Cleveland, TXBuilt 1967 · S/N 15067907N7207TMrzena Matthew D · Wasilla, AKBuilt 1959 · S/N 46807N7207XAbetz Jacob R · Tacoma, WABuilt 1961 · S/N 15059307N7208ECrockett Donald R · Artesia, NMBuilt 1959 · S/N 52208N7208GBurgess Keith · Arnoldsville, GABuilt 1969 · S/N 17258908N7208XReese Scott D · New London, MNBuilt 1961 · S/N 15059308N72091Peralta Jose Ramon · Sinking Spring, PAFirst renewal noticeBuilt 1974 · S/N 18801943TN72094Gibertoni James E · Fairbanks, AKBuilt 1969 · S/N U206-1281N7209GElite Planes LLC · Menifee, CABuilt 1969 · S/N 17258909N7209MColman Aviation LLC · Pocatello, IDBuilt 1958 · S/N 55509N7209QKimble Leon · Rocky Hill, CTBuilt 1972 · S/N 17260509N7209TBouchez Lawrence T · Manhattan Beach, CABuilt 1959 · S/N 46809N7209XSims Hollow M · Lithonia, GABuilt 1961 · S/N 15059309N720FHParadigm Aviation LLC · Anchorage, AKBuilt 1982 · S/N 18504375N720GEHoucke Pascal · Newtown, PABuilt 1975 · S/N 21060671N720SBWhalen John F Jr · West Ossipee, NHS/N 337-0407N720WTBlain Monte W · Joliet, MTBuilt 1962 · S/N 18254350N721Department Of The Interior · Boise, IDBuilt 1981 · S/N U20606256N72106Dahl George Robert · Bethel, AKBuilt 1969 · S/N U206-1282N7210GOgle Howard J · Moorpark, CAS/N 17258910N7210MHensman Bruce E · Steamboat Springs, COBuilt 1958 · S/N 55510N7210NHansen Arthur R · Cheyenne, WYS/N 18263002N7210QAthol Orange Aero Club Inc · Athol, MABuilt 1972 · S/N 17260510N7210SAccelerated Aviation Instruction LLC · Owatonna, MNS/N 15067910N7210XStacey William B · Lebanon, TNBuilt 1961 · S/N 15059310N72113N72113 LLC · Harrah, OKS/N 33701521N72117Ott Steve G · Reedpoint, MTBuilt 1969 · S/N U206-1286N7211ATravis Michael B · Camano Island, WABuilt 1956 · S/N 29311N7211MGasvoda Richard S · Fairfield, MTBuilt 1958 · S/N 55511N7211NGallacci Jefry S · Mattawa, WAS/N 18263003N7211THargrove Nicholas A · Lago Vista, TXBuilt 1959 · S/N 46811N7211XJenkins Joe C · Wyoming, DEBuilt 1961 · S/N 15059311N7212ABlane Steven C · Rockville, INBuilt 1956 · S/N 29312N7212GMeister James A · Star Prairie, WIBuilt 1969 · S/N 17258912N7212MWarhus Donn M · Palmer, AKBuilt 1958 · S/N 55512N7212QLink Air Service LLC · Minong, WIBuilt 1972 · S/N 17260512N7212XBurgess Sheldon · Raymond, MSBuilt 1961 · S/N 15059312N7213NSouth Aero LLC · Albuquerque, NMBuilt 1979 · S/N 21063207N7213QChain O Lakes Flying Club & Co Inc · Waupaca, WIBuilt 1972 · S/N 17260513N7214MOldenkamp Timothy J · Palmer, AKS/N 55514
Back to AD 87-20-03 R2