AD 87-10-06 R1

Registered aircraft · 72,010

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-10-06-R1')
    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-10-06-R1')
  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.

N9163ZPray Aviation Inc · Augusta, KSBuilt 1989 · S/N 2841056N9164CMonmouth Aircraft Services Inc · Toms River, NJBuilt 1978 · S/N R18200433N9164JArizona Airbourne LLC · Gilbert, AZBuilt 1966 · S/N 28-3224N9164SGreat Planes Flyers LLC · Mccook, NEBuilt 1976 · S/N MC-403N9164VMccurry Larry A · Double Oak, TXBuilt 1969 · S/N 690031N9164ZN9164z LLC · Fayetteville, GABuilt 1996 · S/N 27-0213N9165DNelson Vanessa Jump Trustee · Portland, ORBuilt 1958 · S/N 22-6218N9165KCasey Matthey J · Sedalia, COBuilt 1989 · S/N 2890104N9165NJrh LLC · Indianapolis, INBuilt 1989 · S/N 3213020N9165SHufford Christopher · Tucson, AZBuilt 1976 · S/N M-1779N9165VJohnson Michael · Huntington Beach, CABuilt 1969 · S/N 690041N9165WPaleveda Michael · Riverview, FLBuilt 1967 · S/N 28-10790N9166EReed John A · El Centro, CAS/N 7117CN9166JRed Rock Flying School LLC · Mesa, AZBuilt 1966 · S/N 28-3226N9166LSutton Aircraft Salvage LLC · Palmer, AKBuilt 1972 · S/N 319-72N9166PNewman Jeffrey M · Pauline, SCBuilt 1966 · S/N 24-4654N9166SHarris Douglas H · Morgan, UTBuilt 1976 · S/N M-1780N9166TBoling Scott D · Idaho Falls, IDBuilt 1979 · S/N 18-7909065N9166VSiddiqui Shariq M · Poinciana, FLBuilt 1969 · S/N 690035N91673Martin Charles W · Twain Harte, CABuilt 1973 · S/N 17261506N9167JNelson Ryan M · Appleton, WIBuilt 1994 · S/N 27-0168N9167PPegasus Unlimited LLC · Arroyo Grande, CABuilt 1966 · S/N 24-4655N9167SContinental Aviation Club Inc · Lincoln, VABuilt 1976 · S/N M-1781N9167VChapman William Herbert · Dayton, OHBuilt 1969 · S/N 690015N9167WBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 28-10821N9167YComanche Flyers Inc · Gig Harbor, WABuilt 1968 · S/N 31-220N9168EAmerson Scott · Lone Oak, GABuilt 1977 · S/N 7118CN9168J2binc LLC · Adrian, MIBuilt 1966 · S/N 28-3229N9168LMoore Jon · Chuckey, TNBuilt 2003 · S/N 20812N9168QPhillipson Justin M · Vacaville, CABuilt 2001 · S/N 1167N9168VSnow James W · Avon, INS/N 690042N9169DLapaseotes George P II · Sidney, NEBuilt 1958 · S/N 22-6222N9169LSimons Grant C · White Owl, SDBuilt 1971 · S/N 320-72N9169PPorter Christina · Cape Coral, FLS/N 24-4658N9169RDye Rodney D · Marietta, OHBuilt 2003 · S/N D0101N9169THayes George F · Friendsville, PABuilt 1979 · S/N 18-8009012N9169WPutz Michael · Mesa, AZBuilt 1966 · S/N 28-10823N916ALea Martin T · Mesa, AZBuilt 2000 · S/N 001N916ARRowe Stanley P · Pierson, FLS/N 410N916ATKdrd Holdings LLC · Texas City, TXBuilt 1982 · S/N 17275931N916AVLopez Virgilio D · Brookshire, TXS/N 17272800N916BNAir Care Leasing LLC · Lamar, COBuilt 1998 · S/N 21085N916CLDolphin Sales Inc · Wilkes Barre, PABuilt 1975 · S/N 17702273N916DBJj & Sons Aviation Services LLC · Tampa, FLS/N 438N916DPGalliot Bond LLC · Atlanta, GAS/N 27-7654183N916DROliver Randy M · Limerick, MEBuilt 1981 · S/N ROYALL-0001N916HPNeustaeter Pedro Thiessen · Anthony, NMS/N 28-2658N916JAValiair Limited Co Trustee · Casper, WYBuilt 1993 · S/N 4622136N916JCSawyer Tyson D · Mason, NHBuilt 2006 · S/N 448N916JFHammett Gary N · Prince Frederick, MDBuilt 1974 · S/N 28-7405130
Back to AD 87-10-06 R1