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.

N9136NGeorge Richard P Jr · Klein, TXBuilt 1992 · S/N 24-3284N9136RHalderman Floyd Jr · Eldon, MOBuilt 2000 · S/N 23389N9136VDaniels Jeff W · Athens, GAFirst renewal noticeBuilt 1969 · S/N 690022N9136WNotty Woman Holdings LLC · Salado, TXBuilt 1966 · S/N 28-10755N9137EAltitude Holdings LLC · Springfield, MOBuilt 1988 · S/N 3213010N9137HPilots Flying School LLC · Englishtown, NJBuilt 1975 · S/N 17265966N9137JYuma Piper Fliers · Yuma, AZBuilt 1966 · S/N 28-3190N9137PJackson Thomas A Trustee · Maple Grove, MNBuilt 1966 · S/N 24-4618N9137ZBreza Thomas S · Laud By Sea, FLBuilt 1988 · S/N 3206042N9138HMojo Flight Group LLC · Gainesville, GABuilt 1975 · S/N 17265967N9138PSiemering Thomas · Sarasota, FLBuilt 1966 · S/N 24-4619N91396Willard Malcolm · Williston, VTBuilt 1995 · S/N 24-3355N9139CA F S Inc · Grants Pass, ORS/N R18200416N9139TBoss Peter J · Bruce, WIBuilt 1968 · S/N M-1155N9139WAmestoy Flyers LLC · Spokane, WABuilt 1966 · S/N 28-10759N9139ZTseline Aleksei · Cary, ILBuilt 1992 · S/N 24-3285N913BN913b LLC · Eau Claire, WIBuilt 1999 · S/N 25035CN913CBecker Claus · West Palm Beach, FLBuilt 1975 · S/N 32-7640030N913CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8333N913CSSeaman Bruce M · Mohave Valley, AZBuilt 2021 · S/N 71112N913CVMansfield Douglas M · East Gull Lake, MNBuilt 2002 · S/N CV-3N913ECSmith Drake · Dolores, COS/N T20608474N913FBrooks Benjamin · Little Rock, ARBuilt 1991 · S/N 1801N913GDAir Charter Inc DBA · Culebra, PRBuilt 1970 · S/N 198N913GSStull Gary L · Lutz, FLBuilt 2001 · S/N 317N913LKKeller Logan · Vale, ORBuilt 2021 · S/N 70MN913MSCukovic Naim · Portsmouth, NHBuilt 1976 · S/N 28-7715094N913PCRodgers Contract Cutting Inc · Eagle Point, ORS/N 67-16857N913STRuff Randall N · Bay City, MIBuilt 1992 · S/N 5258N913TCPropwash LLC · Sunnyvale, CABuilt 2000 · S/N 3257157N913TGThomas Home Center Inc · Sheridan, ORBuilt 1985 · S/N 28-8616011N913WCPotts Seth A · Mabank, TXBuilt 2009 · S/N 81042N913WGGan Thomas W · Doylestown, PABuilt 2013 · S/N 91887N914Daiber Marcus · Jefferson, GABuilt 1972 · S/N 388HN9140DLee Gerald R · Glennallen, AKBuilt 1958 · S/N 18-6529N9140ESale Reported · Stockholm, SDSale reportedS/N 7112CN9140JKeller Michael A · South Lake Tahoe, CABuilt 1966 · S/N 28-3194N9140MLeblanc Marc · Mohave Valley, AZBuilt 1990 · S/N 27-0083N9140PKing Stephen M · Medford, MABuilt 1966 · S/N 24-4621N9140TKay Aviation LLC · Merritt Island, FLBuilt 1968 · S/N M-1156N9140VN914ov LLC · Greensboro, NCBuilt 1969 · S/N 690028N9140XScoffield Russell C · Hayden, IDBuilt 1991 · S/N 24-3245N9140ZMobley Charles D · Douglasville, GABuilt 1991 · S/N 27-0085N9141JArvizu Alberto P · Lake Havasu, AZS/N 28-3195N9141PSilvabar Air LLC · Springfield, VTS/N 24-4622N9141RInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N 1323N9141VFlitton Mark S · Enterprise, ALS/N 690010N9141WSlater Daniel R · Springfield, OHBuilt 1966 · S/N 28-10762N9142CIndiana Aviation Inc · Nicktown, PABuilt 1978 · S/N R18200417N9142FGontarek Robert E · Plano, TXBuilt 1991 · S/N 27-0087
Back to AD 87-10-06 R1