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.

N9505HFinal Approach Aviation LLC · Danville, CABuilt 1975 · S/N 17266185N9506XBradshaw Aviation Systems LLC · Bridgeton, MOBuilt 1985 · S/N 18268541N9507ALott William F Jr Trustee · Oklahoma City, OKBuilt 1949 · S/N 19068N9507BHanderson Ronald Jr Sr · Sitka, AKBuilt 1957 · S/N 32804N9507LBatra Sanjeev · Roseville, CABuilt 1986 · S/N 17276566N9508BRegistered aircraftBuilt 1981 · S/N 172RG0842N9509GMid Continent Aircraft Corp · Hayti, MOBuilt 1974 · S/N 18801508TN9509TKline John C · Wolcottville, INS/N 57309N9509XHilliard Keith B · Van, TXFirst renewal noticeBuilt 1961 · S/N 21057809N950ACRed Carpet Aviation LLC · Carlsbad, CABuilt 1983 · S/N 17276058N950DRRjc Skyhawk LLC · Middletown, DES/N 17268169N950MEN950me LLC · Manassas, VABuilt 1976 · S/N 17266539N950MGDurante Salvatore · Oro Valley, AZBuilt 1977 · S/N R1722623N950SRAcme Aero LLC · Kingman, KSBuilt 1979 · S/N 21063698N95103Shelton Aviation Inc · Christiansburg, VABuilt 1984 · S/N 15285849N9510HRegistered aircraftBuilt 1975 · S/N 17266188N9510JOrange County Mosquito Control District · Orange, TXBuilt 1981 · S/N 18803814N9510LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276568N9510XWillett Michael J · North Little Rock, ARBuilt 1961 · S/N 21057810N9511BRadford Kenneth J Jr · Chugiak, AKBuilt 1957 · S/N 32808N9511RBrewer William B · Fairbanks, AKBuilt 1985 · S/N U20606881N95122Mcnamara Kevin M Jr · East Aurora, NYBuilt 1984 · S/N 15285852N9512ACook Timothy L · Oklahoma City, OKBuilt 1950 · S/N 19381N9512HTracy Patrick J · Maddock, NDBuilt 1975 · S/N 17266190N9512XSwagerty Michael P · La Mesa, NMBuilt 1961 · S/N 21057812N9512YPalmer George J III · Orlando, FLBuilt 1981 · S/N 21064533N9513BLong Michael A · Grand Lake, COBuilt 1981 · S/N 172RG0844N9513GThomas David · Boise, IDBuilt 1971 · S/N U20601713N9513HHigh Flight Academy LLC · Allison Park, PABuilt 1976 · S/N 17266191N9514GP51d Mustang LLC · Bigfork, MTBuilt 1971 · S/N U20601714N9514HFrerichs John E · Gurley, ALBuilt 1975 · S/N 17266192N95159Kinne Dagmar · Woodburn, ORBuilt 1984 · S/N 15285860N9515BGrason Aviation LLC · Appleton, WIBuilt 1981 · S/N 172RG0846N9515GRegistration Pending · Kenai, AKRegistration pendingS/N U20601715N9515RCunningham Michael K · Pinebluff, NCBuilt 1976 · S/N 18503186N9515XJones Jeffrey A · Rehobeth Beach, DEBuilt 1961 · S/N 21057815N9516AHogan Robert P · North Pole, AKBuilt 1950 · S/N 19384N9516XZeroone Easy Group Inc · Winchester, KYBuilt 1986 · S/N 18268543N9517HPlane Solutions LLC · Kalispell, MTS/N 18267958N9517TSteele Cody T · Polson, MTBuilt 1960 · S/N 57317N9517XKelley James E · Kennewick, WABuilt 1961 · S/N 21057817N9518AFinney Kevin Anthony · Hawthorne, FLBuilt 1949 · S/N 19079N9518GKomer Thomas B Jr · Woodburn, ORBuilt 1971 · S/N U20601718N9518TParks Paul E · Titusville, FLBuilt 1960 · S/N 57318N951CEaston Robert C · Lasalle, COBuilt 1963 · S/N 18051336N951CCBrouchoud Jayson R Trustee · Ridgecrest, CABuilt 1979 · S/N 18266998N951HCUsweixin · Sheridan, WYBuilt 1980 · S/N 172RG0282N9521AWadsworth Harley · Albuquerque, NMBuilt 1949 · S/N 19082N9521HJordan Recreation Development LLC · Clinton, TNBuilt 1975 · S/N 17266197N9521XTailwynns LLC · Lake Placid, FLBuilt 1961 · S/N 21057821
Back to AD 87-20-03 R2