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.

N218AZZavaleta Eric · Abilene, TXBuilt 2008 · S/N 3257486N218TSAeronautica LLC · West Hollywood, CABuilt 1966 · S/N 28-3675N218WGWilliams Sydney E · Kendallville, INBuilt 1969 · S/N 28R-35345N218WPGriffin Kurt J · Gardnerville, NVS/N 28R-7803217N218WSOrourke Brendan W · Stoughton, WIBuilt 1979 · S/N 28-8090094N2190BVeritas Aero LLC · West Lafayette, INBuilt 1978 · S/N 32R-7985014N2190TGonzales Rene V · Lampasas, TXBuilt 1971 · S/N 28-7205029N2191BPetersburg Flying Service LLC · Petersburg, NEBuilt 1978 · S/N 32R-7985015N2191EBel Air Aviation LLC · Chesaning, MIFirst renewal noticeBuilt 1978 · S/N 28-7990179N2191LAir Leasing Service Inc · Hillsborough, NJS/N 28R-7918031N2192TMazza Frank · Bridgeton, NJBuilt 1971 · S/N 28-7205043N2194TNelson Donald M Jr · Fair Oaks, CABuilt 1971 · S/N 28-7205045N2194YDavid Shawn M · Roscoe, ILBuilt 1979 · S/N 28R-7931149N2195EZameroski Daniel C · Mckean, PABuilt 1978 · S/N 28-7990182N2195LGinsberg Andrew P · Rochester, NYBuilt 1979 · S/N 28R-7918032N2195MKorba Sean · San Jose, CABuilt 1979 · S/N 28-7911090N2196NThompson Kurt C · Rochester, MNBuilt 1979 · S/N 32-7940037N2196TTilly Curtis L · Raleigh, NCBuilt 1971 · S/N 28-7205047N2197TAdams Donald L · Huntsville, ALBuilt 1971 · S/N 28-7205048N21985N21985 LLC · Deltona, FLBuilt 1978 · S/N 28-7990066N21992Gilpin Sean F · Madison, ALBuilt 1978 · S/N 32R-7885265N2199HQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 28R-7931005N2199TKeith Brothers Aviation LLC · Fort Worth, TXBuilt 1971 · S/N 28-7205051N219AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843788N219BJTaylor Kennedy E · Courtland, MSBuilt 1967 · S/N 28-22813N219DBN219db LLC · Bryan, OHBuilt 1966 · S/N 28-2970N219DGCtrl Electrical LLC · Lexington, NCBuilt 1999 · S/N 3246134N219JRRoberts Pipeline Inc · Middletown, INBuilt 1973 · S/N 28-7410026N219RMattioli Mark L · Lumberton, NJFirst renewal noticeS/N 28-11302N21ASBoa Properties LLC · Valdosta, GABuilt 1968 · S/N 28R-30862N21DSJohnson Brothers Enterprises Corp · Eldridge, ALBuilt 1968 · S/N 28-24322N21EDHutcheson Jon · Greencastle, INS/N 28-7716031N21KJCherokee LLC · Lewiston, MES/N 28-20307N21LKDalton Versel Jr · Fort Myers, FLBuilt 1973 · S/N 28R-7335207N21PMDalelyn LLC · Claremont, NHBuilt 1979 · S/N 28R-7931118N21TADakota LLC · Wilmington, DEBuilt 1982 · S/N 28-8211041N21TRCareer Aviation Company Inc · Wilmington, DEBuilt 2023 · S/N 28020116N2200JOld Prairie Products Inc · Angola, INBuilt 1979 · S/N 32R7985041N2200SPa32 Aviation LLC · Blue Bell, PABuilt 1979 · S/N 32-7940055N2200YBarber Aviation LLC · Wilmington, DEBuilt 1979 · S/N 28-7911146N2201TCiupitu Marc P · Houston, TXBuilt 1971 · S/N 28-7105182N2202AArtisan Aviation Inc · Rochester, NYBuilt 1978 · S/N 28-7916102N2202LMiles Edward A · Manteno, ILBuilt 1979 · S/N 28R-7931036N2202UAsp Legacy Holdings Corp · SpringwaterBuilt 1979 · S/N 32-7940061N2202WMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-7916332N2202YStanley Aviation LLC · Colby, KSS/N 28-7911147N2202ZHazlewood Norman R · Wichita, KSBuilt 1981 · S/N 28-8116278N2203ASs Three LLC · North Platte, NEBuilt 1978 · S/N 28-7990111N2203DWhytes Inc · Coconut Creek, FLBuilt 1978 · S/N 28-7916148N2203FElk Flyers Inc · Saint Marys, PABuilt 1978 · S/N 28-7990191
Back to AD 87-08-08 R3