OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,413

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-08-08-R3')
    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-08-08-R3')
  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.

N5421WBrown David A · Olympia, WAFirst renewal noticeBuilt 1962 · S/N 28-492N5422SVanwagnen Brian J · Jackson, MIBuilt 1971 · S/N 28-7125118N5424SNeely Benson W · Florence, MSBuilt 1971 · S/N 28-7125119N5425WIrmen Walter Michael Jr · Arlington Heights, ILS/N 28-497N5426FPressley Aviation LLC · New London, NCBuilt 1976 · S/N 28-7715132N5427FRebel Aviation Inc · Liberty, MOBuilt 1976 · S/N 28-7715133N5428FSchold Maury W · Stafford Springs, CTBuilt 1977 · S/N 28-7790118N5428WBon Investment Holdings LLC · Zephyrhills, FLBuilt 1962 · S/N 28-500N5429FQuick Kenneth C Jr · Burke, VABuilt 1976 · S/N 28-7790119N542APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843762N542CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881051N542FLHaffey George F · Fernandina Beach, FLBuilt 1971 · S/N 28-7125374N542HFPars Avn Corp · Wilmington, DEBuilt 1974 · S/N 28R-7435310N542JPGrauer Keaton · Marysville, KSBuilt 1968 · S/N 28R-30772N542KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843866N542MADaystar Aviation LLC · Orange Park, FLS/N 28-7816364N542PUNewbridge Unlimited LLC · Sunny Isles Beach, FLBuilt 2003 · S/N 2844099N542WN542w LLC · Baton Rouge, LABuilt 1975 · S/N 32-7540102N5430FUnion Aviation LLC · El Dorado, ARBuilt 1976 · S/N 28-7790120N5431FSea Container Sales Inc · New Waverly, TXBuilt 1976 · S/N 32-7740004N5431WBig Daddys Casino Inc · Huntington, WVBuilt 1962 · S/N 28-506N5432FHornish Thomas L · Malinta, OHBuilt 1976 · S/N 32R-7780007N5432WVantilborg Craig S · Minot, NDBuilt 1962 · S/N 28-507N5433FNh86 Bumblebee LLC · Henniker, NHBuilt 1976 · S/N 32R-7780008N5435WGabriel Juan J · Melbourne Beach, FLBuilt 1962 · S/N 28-510N54364Parker Realty Co · Brunswick, GABuilt 1973 · S/N 28-7405047N54369Don Warren D · Chandler, AZBuilt 1973 · S/N 28-7425110N5436FTowle Willard M · Lompoc, CABuilt 1976 · S/N 28-7715136N5437FLegacy Aviation LLC · Tea, SDBuilt 1976 · S/N 28-7715137N5437WRoutson David P · Dundee, MIBuilt 1962 · S/N 28-513N54385Mattiello Scott C · Fernandina Beach, FLBuilt 1973 · S/N 28-7415063N5438WHoward Arthur L · Lake City, MNBuilt 1962 · S/N 28-514N54390Mcclelland Kip · Douglas, GAS/N 28-7405049N54391Still Water Security Co LLC · Meriden, CTBuilt 1973 · S/N 28R-7435094N54396Dicey Aviation LLC · Somerset, KYBuilt 1973 · S/N 28-7415055N54398Lashback Communications LLC · Farwell, MIBuilt 1973 · S/N 28R-7435097N5439WRegistration Pending · Gary, SDRegistration pendingS/N 28-515N543CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881052N543FLMorpac Aviation Inc · Wayne, NJBuilt 1971 · S/N 28-7125376N543POracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 28R-7435227N543PUByc Trucking Services LLC DBA · Norco, CABuilt 2003 · S/N 2844100N543RRieck William · Hurricane, UTS/N 28-7921032N543RRFrank Carl · Bakersfield, CABuilt 1979 · S/N 28-7911113N54401Martin Duane C · Brownsburg, INS/N 28-7425120N54405Noel Michael R · Tucson, AZBuilt 1973 · S/N 28-7405051N54410Law Aircraft LLC · Oak Grove, MNBuilt 1973 · S/N 28-7415057N54412Flight Time Builders Inc · Memphis, TNBuilt 1973 · S/N 28R-7435098N54414Panjab Aviation Inc · Las Vegas, NVS/N 28R-7435101N54416Glenn Richard L · York, PABuilt 1973 · S/N 32-7400018N54417Moore Alan J · Hays, KSBuilt 1973 · S/N 32-7440052
Back to AD 87-08-08 R3