OpenAirDocs.org
AD 87-18-06 R1

Registered aircraft · 6,238

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-18-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-18-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.

N207ZMInternational Air Services Inc Trustee · Carson City, NVBuilt 1993 · S/N TH1677N2080LSparks Halli · Burdett, NYBuilt 1976 · S/N D-9902N2082LChronicle Aerospace Inc · Wilmington, DEBuilt 1976 · S/N TK-20N2083LHorizon Chaser LLC · Woodway, TXS/N D-9904N2085LFly More Drive Less LLC · Hot Springs, ARBuilt 1976 · S/N D-9908N2086LMortensen Daniel R Trustee · Newhall, CABuilt 1976 · S/N CE-658N20896Mccullar Miles Glenn · Hagerman, NMBuilt 1977 · S/N E-1163N208PGrateful Center Transportation LLC · Lutz, FLBuilt 1991 · S/N TH-1626N208TMustang Sally LLC · Bullhead City, AZFirst renewal noticeBuilt 1974 · S/N E-572N2090LBarnes Seth M · Hot Springs, ARS/N D-10074N2091LLippert John C · Danville, VABuilt 1976 · S/N E-967N20ACOwen Ray L · Los Gatos, CABuilt 1972 · S/N D9371N20CSChandan Dreamworks Inc · Wilmington, DES/N E-3601N20HMMullett Peter C · Carbondale, COBuilt 1975 · S/N E-750N20RLRose Timothy A · Hickory, MSBuilt 1972 · S/N D-9411N2100EKovach David A Md · Greenwood, INBuilt 1971 · S/N E-290N2105LBishop William E · Fredericksburg, TXBuilt 1976 · S/N D-9912N2106LCht Corp · Lake Forest, CABuilt 1976 · S/N E-878N2107LN2107l LLC · Mishawaka, INBuilt 1976 · S/N E-879N210DAStroemsvik Kristian · Strasburg, VABuilt 1979 · S/N TH-1067N210JLLopez Javier Jimenez · San Antonio, TXBuilt 1985 · S/N E-2208N2110AWindshear Aviation LLC · Longmont, COBuilt 1977 · S/N TJ-129N2110LMalco Power Design Co Inc · La Marque, TXS/N TH-761N2113LGilbert Ben · Omaha, NEBuilt 1976 · S/N D-9917N2116LHagg Theodoor · Johnson City, TNBuilt 1976 · S/N D-9916N2117LCottage Grove LLC · Oklahoma City, OKS/N D-9918N2119LCannon Thomas W · Tiki Island, TXBuilt 1976 · S/N TH-759N211AA1776 Aviation LLC · Kalispell, MTBuilt 1976 · S/N TE-1078N211DGSteel Crazy LLC · Page, AZFirst renewal noticeBuilt 1989 · S/N EA-489N211MVClark Aviation Inc · Greenville, SCBuilt 1999 · S/N E-3244N211MWGoad Jerry A · Oneida, TNBuilt 1973 · S/N TE-923N211VHull Robert Abbott · Payson, AZBuilt 1993 · S/N CE-1754N2123LPanther Air LLC · Alameda, CABuilt 1976 · S/N E-886N2124LMax D Watkins Pc · Tulsa, OKS/N D-9920N2126LLuurtsema Jon A · Alto, MIBuilt 1976 · S/N D-9913N212ASKff Inc · Piscataway, NJBuilt 2001 · S/N TH-1995N212CHFlycarolina Ll · Concord, NCBuilt 1980 · S/N TH-1165N212DEWerre Joel F · Dunn Center, NDS/N EA-626N212MHM L H Properties Inc · Rogers, ARBuilt 1998 · S/N E3209N212PPLermer Christoph · Naples, FLBuilt 1990 · S/N TH-1604N212TDDevane David B Trustee · East Falmouth, MABuilt 1982 · S/N E-1944N212TWLeaving On Tulsa Time LLC · Tulsa, OKBuilt 2000 · S/N TH-1950N212VGuilfoyle Robert J · Fairhope, ALBuilt 1976 · S/N D-9851N2130LTds Property Holdings LLC · Gilmer, TXBuilt 1976 · S/N TK-25N2132LCsrh Ventures LLC · Lubbock, TXBuilt 1976 · S/N D-9923N2133WBeck Robert M · Bakersfield, CABuilt 1974 · S/N CE-502N2134LHeyen John M · Springfield, ILBuilt 1976 · S/N E-890N2135WLeary Kevin · Midland, TXBuilt 1974 · S/N D-9648N2136WMills Robert D · Newport, MIBuilt 1974 · S/N E-568N2137LPcb Air 2 LLC · West Palm Beach, FLBuilt 1976 · S/N CE-662
Back to AD 87-18-06 R1