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.

N9210HFlex Air Holdings Inc · Wilmington, DEBuilt 1975 · S/N 17266017N9210MHahn David · Port Lavaca, TXBuilt 1991 · S/N 11067CN9210NShapiro Sarah Keck · Indianapolis, INBuilt 1993 · S/N 3213046N9210SBazemore Dennis A · Ingleside, TXBuilt 1975 · S/N MC-384N9210VHarrison Joe · Atlanta, TXS/N 690044N9210WSmith Brian · Mechanicsburg, OHBuilt 1967 · S/N 28-10874N9210XMills Anthony D · Midland, MIBuilt 1989 · S/N 3213031N9210YOswald Sean B Trustee · Reno, NVBuilt 1983 · S/N 31P-8414007N92115Stanger Joseph E · Willow, AKBuilt 2021 · S/N 8967N9211CClark Michael J · Grapevine, TXBuilt 2004 · S/N 81579N9211JBrown Herbert R · Halls, TNBuilt 1966 · S/N 28-3280N9211MSowers James Dalton · Park City, KYBuilt 1966 · S/N 3435N9211PBordeleau Michael V · Bridport, VTS/N 24-4706N9211VMorrissey Thomas A · Peachtree City, GABuilt 1969 · S/N 690047N9211WRockwell Tracey W · Atlanta, INBuilt 1967 · S/N 28-10884N9212CMyers Kenneth O · Niskayuna, NYBuilt 1978 · S/N R18200445N9212JJones Greg E · Thomasville, GABuilt 1966 · S/N 28-3281N9212PHapka Leon J · Halma, MNFirst renewal noticeBuilt 1967 · S/N 24-4707N9212VKocher Edward A · Longview, TXBuilt 1969 · S/N 690057N9212WProws Anthony · Othello, WABuilt 1967 · S/N 28-10885N9212YS & B Foundation Air LLC · Auburn, ALBuilt 1983 · S/N 31P-8414008N92131Cavu Flyers Of Long Island Inc · Ronkonkoma, NYBuilt 1973 · S/N 17261546N9213EHolman Michael · Wasilla, AKBuilt 1977 · S/N 7134CN9213JRegistered aircraftBuilt 1966 · S/N 28-3283N9213KCarver Clarence K · Lutz, FLBuilt 1976 · S/N 28-7625170N9213YCarty Eric · Anchorage, AKBuilt 1971 · S/N 18-8918N92141High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 17261549N9214FMaule N889z Inc Trustee · Wilmington, DEBuilt 1991 · S/N 4105CN9214HJem Aviation Ltd · Wilmington, DEBuilt 1990 · S/N 4622114N9214JSale Reported · Hurdsfield, NDSale reported, pending cancellationBuilt 1966 · S/N 28-3284N9214SC&L Aviation LLC · New London, WIBuilt 1975 · S/N M-1737N9214VGostomski Michael J · Yacolt, WABuilt 1969 · S/N 690049N9214WManning John · Oro Valley, AZBuilt 1967 · S/N 28-10878N92159Buster Aviation LLC · Harveys Lake, PABuilt 1973 · S/N 17261550N9215DToga LLC · Cumming, GABuilt 1990 · S/N 3213037N9215JGrizzard Shawn C · Hayden, IDS/N 28-3285N9215SGarner James L DBA · Pelham, ALBuilt 1973 · S/N M1711N9215VGonzalez Cruz · North Las Vegas, NVS/N 690045N9215YAstro Star Aviation Inc · Niles, MIBuilt 1968 · S/N 31-279N92161Skywarrior Flight Training Inc · Pensacola, FLBuilt 1973 · S/N 17261551N92169Welch William Ben · Danville, ILBuilt 1973 · S/N 17261553N9216DBlackbird Aviation LLC · Bedford, PABuilt 1958 · S/N 22-6276N9216HBurgess Alan P · Corona, CABuilt 1975 · S/N 17266020N9216JSantana Alexandre C · Long Beach, CABuilt 1966 · S/N 28-3286N9216MLewellen Richard H · Mount Vernon, WABuilt 1966 · S/N 3437N9216NSligh Mark G · Cantil, CABuilt 1968 · S/N 67-16865N9216PWilliams Dayre · Red Cloud, NEBuilt 1967 · S/N 24-4712N9217DBischoff Danielle I · Palmer, AKBuilt 1958 · S/N 22-6277N9217EGranberry Philip · Anchorage, AKBuilt 1977 · S/N 7135CN9217JWaicekauskas Joe · Raymondville, MOBuilt 1966 · S/N 28-3287
Back to AD 87-10-06 R1