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.

N7112GHooper Walter E III · Spring City, TNBuilt 1969 · S/N 17258812N7112KHamann Hunter R · Spokane, WABuilt 1950 · S/N 18-329N7112LDoskicz Harry N · Slatington, PAS/N AA5-0612N7112PNouri Kamyar · Fullerton, CAS/N 24-2269N7112RMarshall Air LLC · Bellevue, MIBuilt 1966 · S/N 28-21811N7112WKeesee Bill · Meadow, TXBuilt 1962 · S/N 28-903N7113DN7113d LLC · Ardmore, OKBuilt 1957 · S/N 22-4971N7113LBlanton Ronald · Lascassas, TNBuilt 1974 · S/N AA5-0675N7113PWallace Lonnie Roy · Charlotte, NCBuilt 1960 · S/N 24-1879N7113QMiles Michael G · Hillsborough, NCBuilt 1972 · S/N 17260413N7113RNewton Dennis E · Surprise, AZBuilt 1966 · S/N 28-21812N7113WHigh Flyers Inc · Benson, AZS/N 28-961N71141Av8 Flight Assets LLC · Eden Prairie, MNBuilt 2017 · S/N 2843910N71143Av8 Flight Assets LLC · Eden Prairie, MNBuilt 2017 · S/N 2843911N7114AMy Air Mira LLC · Eagan, MNBuilt 2017 · S/N 2843912N7114BShore Brian R · Carmichael, CABuilt 1956 · S/N 22-4331N7114CAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2017 · S/N 2843913N7114DPierce Brian L · Grants Pass, ORBuilt 1957 · S/N 22-4972N7114JAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2017 · S/N 2843914N7114PP & G Aviation LLC · Omaha, NEBuilt 1960 · S/N 24-2272N7114QSass Kenneth · Charlotte, NCBuilt 1972 · S/N 17260414N7114RUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1999 · S/N 0623N7114UMaximizing Abilities Through Training Two DBA · Independence, MOBuilt 1964 · S/N 356N7114VCross Wings Aviation LLC · San Antonio, TXBuilt 1974 · S/N 22-0049N7114WEstes Shannon L · Pace, FLBuilt 1962 · S/N 28-905N7114YAymerich Marc · Belvedere, CABuilt 1963 · S/N 30-135N7114ZSchwend Brian · Forsyth, MTBuilt 1964 · S/N 25-2909N7115LAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843915N7115PKutner Michael S · Nichols Hills, OKBuilt 1960 · S/N 24-2273N7115QMaggart Kenneth R · Lutz, FLBuilt 1972 · S/N 17260415N7115WLambert Scott E · Shamong, NJBuilt 1962 · S/N 28-906N7115YMcdade Nimrod R III · Smyrna, TNBuilt 1963 · S/N 30-136N7116DSeelinger Donald P · Seldovia, AKBuilt 1957 · S/N 22-4976N7116QStogner Sarah E · Monahans, TXBuilt 1972 · S/N 17260416N7116RBastian Dennis L · Burns, WYBuilt 1966 · S/N 28-21816N7116VPeterson Robert E · Mobile, ALBuilt 1974 · S/N 20-0029N7116YSinclair Air LLC · Shallowater, TXBuilt 1963 · S/N 30-77N7117BSale Reported · Chelsea, MISale reportedBuilt 1956 · S/N 22-4334N7117EDowell Cameron C · Solomons, MDBuilt 1974 · S/N MC-278N7117GBaker Brady B · South Hero, VTBuilt 1969 · S/N 17258817N7117PRegistration Pending · Sandia, TXRegistration pendingBuilt 1960 · S/N 24-2275N7117VNrv Flyers Inc · Blacksburg, VABuilt 1974 · S/N 20-0030N7117WMitchell Cameron A · Hopkinsville, KYBuilt 1962 · S/N 28-908N7118PSuarez Aaron M · La Habra Heights, CAS/N 24-2276N7118QMartin Stephen T · Green Cove Springs, FLBuilt 1972 · S/N 17260418N7119BDelaney Patrick J · Marion, TXBuilt 1956 · S/N 22-4336N7119DBuell Travis · Harper, TXBuilt 1999 · S/N 2939N7119MSutton Aircraft Salvage LLC · Palmer, AKBuilt 1958 · S/N 55419N7119PLowry Wilson R · Leonardtown, MDBuilt 1960 · S/N 24-2278N7119UTtwn Media Networks LLC · New York, NYBuilt 1999 · S/N 0641
Back to AD 87-10-06 R1