OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,413

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-08-08-R3')
    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-08-08-R3')
  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.

N5057TGiber Michael S · New Port Richey, FLBuilt 1972 · S/N 28-7225338N5058TRebel Aviation Inc · Liberty, MOBuilt 1972 · S/N 28-7225339N5059TGimenez Roberto Jorge · Merritt Island, FLS/N 28-7205244N505AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2020 · S/N 28020005N505FLComer Christopher C · Randleman, NCBuilt 1971 · S/N 28-7125325N505GSVolar Corp · El Cajon, CABuilt 1977 · S/N 28-7890275N505SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881420N505WCQualitair LLC Trustee · MichelstadtBuilt 1996 · S/N 3246034N5060TAirzona Aircraft Services Inc · Kingman, AZBuilt 1972 · S/N 28R-7235187N5061TSullivan Patrick James · Avery, CABuilt 1972 · S/N 28R-7235188N50637Great Planes Aviation Inc · Rochester, MNBuilt 2001 · S/N 2843419N5063SLancon James B · Prescott, AZBuilt 1970 · S/N 28R-35812N5063TKramer Ryan T · Hector, MNBuilt 1972 · S/N 28-7225341N5065WAddai Emmanuel · Cincinnati, OHBuilt 1961 · S/N 28-74N5066TLee Miesner Aviation LLC · Park Hills, MOBuilt 1972 · S/N 28R-7235190N5067SSinatsch Christian C · Saint Augustine, FLS/N 28R-35810N5068PRussell David D · Humble, TXS/N 3257207N5069SMccarron Michael · Cary, ILBuilt 1971 · S/N 28R-7135074N5069WNelson Stephen A · Milaca, MNBuilt 1961 · S/N 28-78N506CVail Jeffrey · Kennett Square, PABuilt 2004 · S/N 3255015N506CJMatthews Joseph R · Bartlett, TNBuilt 1979 · S/N 28R-8018028N506NDUniversity Of North Dakota · Grand Forks, NDS/N 2881780N506RBChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 2843092N506XLyons Leasing LLC · Zionsville, INBuilt 2003 · S/N 3232002N5071LHill Karl D · Igiugig, AKBuilt 1967 · S/N 28-4456N5071WWallace Madison F · Thomasville, NCBuilt 1961 · S/N 28-80N5072WHurst Randall S · Altus, ARBuilt 1961 · S/N 28-81N5074WWells Byron R · Bunn, NCS/N 28-83N5077WSkyport Aviation LLC · Birmingham, IAS/N 28-86N5078MHolcomb Chris · Amarillo, TXBuilt 1963 · S/N 28-10111N507AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2020 · S/N 28020006N507FLSpence Ryan · Chicopee, MABuilt 1971 · S/N 28-7125328N507GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881179N507MAAviation Consultants US Inc · Beaver Falls, PABuilt 2004 · S/N 3255014N507SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881421N5080WMatzke Kevin T · Gilbert, AZBuilt 1961 · S/N 28-89N5081SDream Factory Aviation Inc · Henderson, NVBuilt 1971 · S/N 28R-7135081N5083SRiser Air LLC · Stillwater, MNBuilt 1971 · S/N 28R-7135082N5084WShouse Robert G · Owasso, OKBuilt 1961 · S/N 28-93N5085SHall Thomas K · Beaufort, NCBuilt 1971 · S/N 28R-7135085N5085WMartin Marlin Ray Jr · Mabank, TXBuilt 1961 · S/N 28-94N5086SAero Air Inc · Salt Lake City, UTBuilt 1971 · S/N 28R-7135086N5088MGeneral Aviation Partners LLC · Madison, ALBuilt 1967 · S/N 28-10928N5088SSwaz Aviation LLC · Mesa, AZBuilt 1971 · S/N 28R-7135089N5089STye Richard Ray · Silverado, CABuilt 1971 · S/N 28R-7130004N508AFAmerican Air Academy Inc · Merritt Island, FLBuilt 2020 · S/N 28020007N508DXPiper Aircraft Inc · Vero Beach, FLS/N 28010108N508RFFugate Richard Dee · Rochester, MNBuilt 1981 · S/N 28-8190281N508THFowler David P · Freeport, MEBuilt 1967 · S/N 28-22869N5090SSturm Neal M · Randolph, NJBuilt 1971 · S/N 28R-7135091
Back to AD 87-08-08 R3