OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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.

N129JPSlezak Douglas C · Atascadero, CAS/N 003N129JZThomas James E · Forsyth, GABuilt 2002 · S/N 60321N129MAAttwood Nicholas John · Ashburn, VAS/N 2890219N129MBYellowfin Air Services LLC · Wilmington, DEBuilt 1971 · S/N 3108N129MFAviation Sciences LLC · Cambridge, MABuilt 1984 · S/N 129N129MSWinging It LLC · Kalispell, MTBuilt 2004 · S/N 3712N129MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496172N129RCAirris Aviation & Marine Co · N Fort Myers, FLBuilt 1993 · S/N 27-0173N129RVVans Aircraft Inc · Aurora, ORBuilt 2000 · S/N 2N129SAero Quest LLC · Olive Branch, MSBuilt 1974 · S/N 17263118N129SEBarrington Air Inc · Littleton, COBuilt 1998 · S/N 18280384N129SJWorking Capital Group LLC · Rogers, ARBuilt 2001 · S/N 129N129SLLee Aero LLC · Wichita, KSBuilt 1979 · S/N 17273503N129SYDaigle Danny · Greenville, MEBuilt 1978 · S/N 17270741N129TBPeer Thomas A · Tullahoma, TNBuilt 2018 · S/N 82289N129TFGary Boyce Aircrft Sales LLC · Shelbyville, TNBuilt 2026 · S/N 70673N129WMSky Solutions LLC · Detroit, MIBuilt 2004 · S/N 10564N129WTHill Tool LLC · Missoula, MTBuilt 2014 · S/N 001N129XCCatbird Cub LLC · Tampa, FLBuilt 2019 · S/N CC19-0047N129YEBuell Travis W · Harper, TXBuilt 2002 · S/N 3334N12ACCarroll Alan R · Mc Farland, WIBuilt 2005 · S/N 80177N12ADAltizer John N · The Woodlands, TXBuilt 1994 · S/N JWA-2N12AKBurk Ross T · Casper, WYS/N 5695N12ALFuller Deidra K · Great Falls, MTBuilt 1981 · S/N DAV-1N12BEElliott Russell R · Wasilla, AKS/N 7082CN12BHMunk-Ee Business Aviation LLC · Linden, MIBuilt 1956 · S/N 157-195N12BJValentour Lance F · Naperville, ILBuilt 1974 · S/N 17264570N12BVRoberts William O · Lexington, VAS/N 0241N12CGGreen Carlton · Carmel Valley, CABuilt 1996 · S/N 1320N12CKAmoss Harold Lindsay III · Redmond, ORBuilt 1990 · S/N 5179N12DDSpencer William D · Martinsville, VAS/N 248N12DPKish Gary A · Montrose, MIBuilt 1975 · S/N 1212DN12DSBuckbee Robert E · College Station, TXBuilt 1984 · S/N 27N12EEArizona Cloudbusters Inc · Mesa, AZS/N 18280038N12ERPropelling The Gospel Missions Inc · Standish, MEBuilt 1976 · S/N 28-7615099N12FMDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816439N12FPElliott James R · Denton, TXBuilt 1974 · S/N 238N12FSLawley Frederick E · Bozeman, MTBuilt 1966 · S/N 30-1226N12GANy Flying Tigers LLC · Ronkonkoma, NYBuilt 1977 · S/N AA5B0635N12GCNorman Ashton J · Zanesville, OHBuilt 2000 · S/N 2264N12GEJ&P Master Flooring Corp · Lauderdale Lakes, FLBuilt 1974 · S/N 27-7405422N12GLHayden Debra J · Utica, KYBuilt 1995 · S/N JR-2N12GNNauta Gordon Wayne · Palmdale, CABuilt 1977 · S/N 112N12GRJones Richard B · Georgetown, TXBuilt 2001 · S/N 2152N12HEOlafsen George F · Greeneville, TNBuilt 2007 · S/N 91367N12HFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020131N12HGNaylor John H · Conway, ARS/N 1N12HHWilliams Jeffrey · Florence, ALBuilt 1989 · S/N 1688N12HPState Of Ohio · Columbus, OHBuilt 2002 · S/N 18281158N12HRHarben Grover S III · Gainesville, GABuilt 1991 · S/N 1664
Back to AD 87-10-06 R1