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.

N9030FDesouza Ferdinand E · El Prado, NMS/N 454N9030JSunrise Aviation Group LLC · Kalispell, MTBuilt 1966 · S/N 28-3058N9030LDavis Robert L · Seymour, TNBuilt 1970 · S/N 216-70N9031JBaumgartner Matthew J · Federal Way, WABuilt 1966 · S/N 28-3059N9031LSanderlin Doulgas C · Wasilla, AKBuilt 1970 · S/N 253-70N9032CGoodman Kim J · Burnsville, NCBuilt 1978 · S/N R18200377N9032LJohnson Robert W · Buffalo, SDBuilt 1970 · S/N 259-70N9032WPringle Craig Marlin · Winfield, KSS/N 28-10624N90339Bas Part Sales LLC · Greeley, COBuilt 1975 · S/N 61P-0196-015N9033JBernstein Matthew D · North Charleston, SCBuilt 1966 · S/N 28-3062N9033LBickmore David L · Bay City, MIBuilt 1970 · S/N 260-70N9033PMiddletown LLC · Chandler, AZBuilt 1966 · S/N 24-4495N90346Mittelsted John J · Dickinson, TXBuilt 1967 · S/N 27-3604N90347R & S Aircraft LLC · Wilmington, DEBuilt 1946 · S/N 361N90349Williams David Anthony · Port Saint Lucie, FLBuilt 1975 · S/N 60-0202-090N9034JGrammer Steve J · Redding, CABuilt 1966 · S/N 28-3063N9034PNational Test Pilot School · Mojave, CABuilt 1966 · S/N 24-4496N9036DKranz Monte L · Eagle Butte, SDBuilt 1958 · S/N 22-6174N9036JBernau Bodies Fitness LLC · Mesa, AZBuilt 1966 · S/N 28-3066N9036KGriffiths Gregory S · Johnson City, NYBuilt 1977 · S/N 28-7816184N9036LWhitmer Charles W · Fairbanks, AKBuilt 1970 · S/N 264-70N9036NRobinson Helicopter Co · Torrance, CABuilt 1981 · S/N 0089N9036RBaltz David M · Superior, COBuilt 1978 · S/N R18200658N9037JMcgough Julie E · Red Oak, TXBuilt 1966 · S/N 28-3067N9037PJack Ryan Aviation · Woodcliff Lake, NJS/N 24-4500N9038DJones Michael D · Eagle River, AKBuilt 1958 · S/N 22-6176N9038FGrupp Wayne · Wayne, ILBuilt 2006 · S/N 1N9038HPeterson Todd B · Cameron Park, CABuilt 1975 · S/N 17265912N9038KNorthwest Aviation LLC · Gig Harbor, WABuilt 1977 · S/N 28-7816185N9038YRodriguez Juan M · Grass Valley, CABuilt 1983 · S/N FM2N9039CDouble O Seven Limited Co · Carefree, AZBuilt 1978 · S/N R18200378N903CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8327N903DRCrosgrove Shawn R · Riverton, UTBuilt 2013 · S/N 82372N903EESkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843229N903EPEshuis Herman · Lake City, FLBuilt 2007 · S/N 267N903FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842175N903HWJackson Construction Services LLC · Wichita Falls, TXBuilt 1973 · S/N 32-7340068N903KCHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1991 · S/N 1640N903NBEllis David E · Midlothian, TXBuilt 2009 · S/N 001N903NSAmerican Patrols Inc · Midland, TXBuilt 1976 · S/N 17267441N903SDWernli Donald R · Perry, IABuilt 2003 · S/N 2437N903USSchneider Charles · Sioux Falls, SDBuilt 1966 · S/N 28-3068N9040JEllis James E Trustee · Harvard, MABuilt 1966 · S/N 28-3070N9040KGidden Aviation LLC · Katy, TXBuilt 1977 · S/N 28-7816186N9040PMcclure Jared · Claremore, OKBuilt 1988 · S/N 1152N90419Goodhue Clinton H · Sidney, MEBuilt 1967 · S/N R172-0254N9041DHamlin Ryan C · Naples, MEBuilt 1958 · S/N 22-6179N9041EGallagher Joshua Michael · Fromberg, MTBuilt 1977 · S/N 7073CN9042DGage Ricky D · Lewiston, IDBuilt 1958 · S/N 22-6180N9042HSt Pete Aviation Services LLC · St Petersburg, FLS/N 17265914
Back to AD 87-10-06 R1