OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,007

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.

N333YZeller Ty F · Trego, WIBuilt 1969 · S/N 7GCBC-194N333YFEagle Aviation LLC · Delray Beach, FLBuilt 1978 · S/N R18200747N333ZMMuzzio Lewis · Chandler, AZBuilt 2022 · S/N 83607N33404Marrero Jeffrey Tomas · Gainesville, FLBuilt 1975 · S/N 28-7515302N33405Appoloney Robert · Walnut, CABuilt 1975 · S/N 28-7515335N33408Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 32-7500021N3340QHickey Aero Services LLC · White Hills, AZS/N 32R-7780307N33411Pumpelly Thomas H · Dayton, OHFirst renewal noticeBuilt 1975 · S/N 32-7540098N33417Mercer Aviation Group LLC · Mercer Island, WABuilt 1975 · S/N 28-7515336N3341LSky Chem LLC · Downingtown, PABuilt 1976 · S/N MC-462N3341PDahl Troy M · Cedar Rapids, IABuilt 1958 · S/N 23-1294N3341TWatson Dennis R · Fort Worth, TXBuilt 1967 · S/N 17700641N33420Rooney George A III · Colts Neck, NJBuilt 1975 · S/N 28R-7535148N33424Macair Aviation LLC · Xenia, OHBuilt 1975 · S/N 28-7515337N3342WTwo Sons Aero LLC · Wilmington, DEBuilt 1965 · S/N 32-181N3342ZNies Juergen · Winchester, VABuilt 1960 · S/N 22-7282N33432Atmospheric Vehicle & Spacecraft Flt Exploration · Rch Palos Vrd, CABuilt 1975 · S/N 28-7525189N33439Whitehead Christopher L · Palmetto, GAS/N 28-7515299N3343LFreid Paul E · Southport, NCBuilt 1976 · S/N MC-466N3343QGallmeyer Vernon H DBA · Louisville, COS/N 28-7716151N3343TMcclellan Dabney B · Centerburg, OHBuilt 1967 · S/N 17700643N33443Warmsley Aviation LLC · Fort Washington, MDBuilt 1975 · S/N 28-7525193N33444Mossbarger Beverly Jo · Jamestown, OHBuilt 1975 · S/N 28-7505146N3344JSaitto Jeffrey M · Media, PAS/N 15066044N3344LBlauner Peter D · Coatesville, PABuilt 1976 · S/N MC-467N3344NGan Jeff P · Ramona, CABuilt 2011 · S/N 41020N3344PLachausse Kevin J · Woodville, TXBuilt 2013 · S/N 41362N3344QGrinch Robert J · Ridgewood, NJBuilt 1977 · S/N 28-7790452N3344SLewis James P Jr · Castle Rock, COBuilt 1965 · S/N 710N3344WGracey Kenneth · Burien, WABuilt 1965 · S/N 32-184N33459A-Z Leasing LLC · Kenosha, WIBuilt 1975 · S/N 28-7515340N3345KClevenger Jim B · Kissimmee, FLBuilt 1946 · S/N 1338N3345TJefts Donald R · Scotia, NYBuilt 1967 · S/N 17700645N33460Sportsman Airpark Inc · Newberg, ORBuilt 1975 · S/N 28-7505147N33462Becker Barton C DBA · Oneill, NES/N 28-7505149N3346EEarnst Kelly S · West Lafayette, INBuilt 1978 · S/N 17271512N3346PDramstad Flying Service LLC · Helena, MTS/N 23-1299N33480Cerva Air LLC · New Albany, INBuilt 1975 · S/N 28-7515341N33482Poulton Robert J · Lincoln, RIBuilt 1975 · S/N 28-7505150N33483Blue Wings Aviation LLC · Camden, SCBuilt 1975 · S/N 28-7505151N33485Bruner Timothy R · Laurel, MDBuilt 1975 · S/N 28R-7535154N33488Mcintyre William H · Waterloo, ALBuilt 1975 · S/N 28-7515304N3348TWarhol Peter J · Peever, SDBuilt 1971 · S/N 28-7125330N3348VSullivan Jon L · Lincoln, NEBuilt 2022 · S/N 4518N3348WCyrus Ely G · Kiana, AKBuilt 1965 · S/N 32-189N33491Love Steven J · Rio, ILBuilt 1975 · S/N 28R-7535155N33496B A T S Aviation LLC · Long Island, KSBuilt 1975 · S/N 32-7540103N3349CCabrera John F · Glendale, CABuilt 1978 · S/N R18200274N3349MDunkley Bret Y · Kotzebue, AKBuilt 1947 · S/N 12-2208N3349SJin Jin Aviation LLC · Anchorage, AKBuilt 1984 · S/N 17276255
Back to AD 87-10-06 R1