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.

N6247JInternational Air Services Inc Trustee · Carson City, NVS/N 28-7690380N6247LChandler Air Service Inc · Chandler, AZBuilt 1976 · S/N 0733N6247USchaefer John A · Liberty Hill, TXBuilt 1962 · S/N 2086N62486486 Aviation LLC · Worthington, OHBuilt 1981 · S/N 17275280N62488Leaf Air LLC · Queensbury, NYBuilt 1981 · S/N 17275282N6248CFort Leavenworth Flying Club · Fort Leavenworth, KSS/N 28-7816629N6248DEscobar Frank · Tampa, FLBuilt 1979 · S/N 17272663N6248MRoss Michael M Trustee · Anchorage, AKBuilt 1978 · S/N 7201CN6248RHewitt Chad R · Vernonia, ORS/N 188320N62491Registration Pending · Strawn, TXRegistration pendingS/N 18-7709037N62494Pacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7654019N62495Gentrys Flying Service LLC · Prattville, ALBuilt 1976 · S/N 277654020N62498Hogan Michael J · Bonita Springs, FLBuilt 1975 · S/N 27-7654023N6249JAkwari Aerospace LLC · Burbank, CABuilt 1976 · S/N 32R-7680340N6249PKeller Richard A · Stacy, MNBuilt 1959 · S/N 24-1356N6249VN6249v LLC · Park Ridge, ILBuilt 1980 · S/N 172RG0596N6249WWall Scott R · Franksville, WIBuilt 1964 · S/N 28-20295N6249YPapagni Demetrio G · Madera, CAS/N 27-3487N624ACAnunson Andrew M · Pound, VABuilt 2022 · S/N 1273N624APThomas Lucas G · Beebe, ARBuilt 1978 · S/N 274-78N624AQHigh Flight Academy LLC · Allison Park, PABuilt 1984 · S/N 28-8416122N624BBPetey LLC · Lake Arrowhead, CABuilt 1997 · S/N 14651N624BTJespersen Barry W · Olympia, WAS/N 91944N624CECertified Equipment Inspections LLC · Washington, PAS/N 462N624CJJones Steven Clark · Flagler Beach, FLBuilt 2020 · S/N 2881427N624CWSkypeck John · Nevada City, CABuilt 1980 · S/N 32-8006022N624DGRv4 Adventures Inc · Wilmington, DEBuilt 1998 · S/N 3499N624DPHamons Spencer · Cookson, OKBuilt 1981 · S/N 32-8124033N624FTFlorida Institute Of Technology · Melbourne, FLBuilt 1979 · S/N 28-7916446N624GTTrue Lumen Aviation LLC · Grosse Pt Shr, MIBuilt 1978 · S/N 32R-7987041N624HNeed For Speed Inc · Dover, DEBuilt 1977 · S/N 1078N624JTStandhart Gary · Wickenburg, AZBuilt 2013 · S/N TC0611003N624LLLevin Larry R · Lincoln, RIBuilt 1998 · S/N 1876N624MCStauffer Mark A · Appleton, WIBuilt 2008 · S/N 90579N624MEPetry Christopher M · Frankfort, ILFirst renewal noticeBuilt 1969 · S/N 31-624N624MSMcclure George E Jr · Nipomo, CABuilt 2001 · S/N 25123N624NDZaki Amir S · Orangevale, CABuilt 1995 · S/N 20359N624RCJeffrey Guy · Centerburg, OHBuilt 1993 · S/N 318N624SStoro Eddy · Netarts, ORBuilt 2000 · S/N 80620N624SEPrysi Mary H · Dundee, OHBuilt 1958 · S/N 186576N624SXDeeds Andy · Larkspur, COBuilt 2019 · S/N 41915N624TCArnaoutis Antonios D · Ormond Beach, FLBuilt 2022 · S/N 74737N624TFDominy Kenneth W · Ave Maria, FLFirst renewal noticeBuilt 2006 · S/N 5405N62502Hill Andrew T · Smithville, TXS/N 17275284N62503Back Forty Flying Club Inc · Roanoke, INBuilt 1981 · S/N 17275285N62508Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7654029N6250CShields Ray Winfrey III · Marietta, GAS/N 28-7890357N6250UAsb Jones Aviation · Uniontown, OHBuilt 1962 · S/N 2089N6250WCummings Property Restoration LLC · Bullard, TXBuilt 1964 · S/N 28-20296N62511Dezee Matthew J · Corinth, KYBuilt 1981 · S/N 17275289
Back to AD 87-10-06 R1