OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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.

N724AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843790N724ATH Squared Aviation LLC · Sheridan, WYBuilt 1984 · S/N 32R-8429027N724CASouth Shore Flying Club Inc · South Weymouth, MABuilt 1999 · S/N 2843224N724DWParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020124N724FLUncle Tommy LLC · Aurora, ILBuilt 1972 · S/N 28-7225417N724LPBone Aviation LLC · Calhoun, GABuilt 1968 · S/N 28-4962N724RStardust Aviation LLC · Farmingdale, NYBuilt 2003 · S/N 2843543N7250JBrandenburg Carl A Jr · Goodyear, AZBuilt 1968 · S/N 28-24592N7250WHuber Peter Michael · Pulaski, VABuilt 1963 · S/N 28-1078N7251FWright Charles W · Selbyville, DEBuilt 1968 · S/N 28-25168N7251JChapman Michael S · Cardington, OHBuilt 1968 · S/N 28-24593N7252JMedina Jose · Spring, TXBuilt 1968 · S/N 28-24594N7253JLeffler William J · Tucson, AZBuilt 1968 · S/N 28-24595N7253WGross Matthew A · Ridgecrest, CABuilt 1963 · S/N 28-1081N7254FWolf Kim A · East Wenatchee, WAS/N 28-25172N7254JMinkel Chad A · Chanhassen, MNBuilt 1968 · S/N 28-24597N7254WMonroe County Flyers And Sales LLC · Sweetwater, TNS/N 28-1083N72551Gonzalez Christian · Manati, PRBuilt 1964 · S/N 28-10230N7255FN7255f LLC · Cedar City, UTBuilt 1968 · S/N 28-25173N7255JRury Bryan · Midlothian, TXBuilt 1968 · S/N 28-24598N7256FZihala William · North Little Rock, ARBuilt 1968 · S/N 28-25174N7257FHedberg Jacob R · Jordan, MNS/N 28-25175N7257JHardin John M · Terrell, TXBuilt 1968 · S/N 28-24601N7258CRegistered aircraftBuilt 1975 · S/N 28-7690063N7258FCochran Brent D · Sandy Valley, NVBuilt 1968 · S/N 28-25177N7259CN7259c LLC · Indianapolis, INBuilt 1975 · S/N 28-7690064N7259FLearn 2 Fly Ct LLC · Simsbury, CTBuilt 1976 · S/N 28-7715205N725DGRed Pine Exploration & Research LLC · Boca Raton, FLBuilt 1977 · S/N 32-7840032N725NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881620N7260FRandy'S Rodz LLC · Missoula, MTBuilt 1968 · S/N 28-25178N7260WO'Day John E · Rindge, NHBuilt 1963 · S/N 28-1092N7261WKurywchak Daniel A · Cameron Park, CABuilt 1963 · S/N 28-1093N7262FParlee Chad E · Lakeport, CABuilt 1968 · S/N 28-25181N7262JKemp Lyman E · Ketchikan, AKBuilt 1968 · S/N 28-24584N7262WDube Colin T · Minot, MEBuilt 1963 · S/N 28-1095N7263JKl Aviation LLC · Catawba, NCBuilt 1968 · S/N 28-24548N7263WKontour Shawn K · Wheatland, WYBuilt 1963 · S/N 28-1096N7264FPodyaire LLC · Ruston, LAS/N 28-25184N7264JHoseney Richard W Jr · Como, MSBuilt 1968 · S/N 28-24532N7264WFehringer John T · Sidney, NES/N 28-1097N7265FShouling & Philip Enterprise · Lancaster, CAS/N 28-25185N7265JSwoboda Charles · Anchorage, AKBuilt 1968 · S/N 28-24528N7265WSayles Michael A · Shorewood, ILBuilt 1963 · S/N 28-1098N7266JPaolo Keath R · Carlton, ORBuilt 1968 · S/N 28-24520N7266WNewland Hunter R · West Valley City, UTBuilt 1963 · S/N 28-1099N7267FRegistered aircraftBuilt 1968 · S/N 28-25187N7267JSe Aviation LLC · Boise, IDBuilt 1968 · S/N 28-24464N7267WGillespie Michael Lee · Jacksonville, FLBuilt 1963 · S/N 28-1185N7269FChandler Joseph · Amana, IABuilt 1968 · S/N 28-25191N7269WButtercup Express LLC · Woodward, OKS/N 28-1103
Back to AD 87-08-08 R3