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.

N9502MStorer Daniel A · Guthrie, OKBuilt 1966 · S/N 670079N9502WHellevang Ryan K · Duvall, WAS/N 28-22924N9503DHardison Allan · Castle Rock, COS/N 22-6418N9503MCurell Kenneth E · Centerville, OHBuilt 1966 · S/N 670080N9503PClark Chris E · Sandy, UTBuilt 1972 · S/N 24-5020N9503QGulf Coast Helicopters Inc · Pearland, TXS/N 18280075N9503UAom Aircraft LLC · Wilmington, DES/N 008N9503WLoya Armando · Whittier, CAS/N 28-22925N9503YRoss Carl D · Arbuckle, CABuilt 1998 · S/N 18280215N95044Mach Point Two Aviation LLC · Conroe, TXBuilt 1969 · S/N 28-25783N9504DWilliams Jimmy Z · Sherman, TXBuilt 1958 · S/N 22-6419N9504FRons Air Service Inc · Two Buttes, COBuilt 1968 · S/N 870334N9504HPatterson Clifford Wayne · Murphy, TXBuilt 1975 · S/N 17266184N9504LTaylor William C · Portsmouth, NHBuilt 1998 · S/N 18280210N9504MNawratil Nicholas · Richmond, TXBuilt 1966 · S/N 670081N9504WS&J Aviation LLC · Burlington, WABuilt 1967 · S/N 28-22926N95053Jamesweathers Robi J · Blaine, MNBuilt 1969 · S/N 28-25788N9505DJutzi Curtis E · Ridgefield, WABuilt 1958 · S/N 22-6420N9505EKelso Ted M · Fort Worth, TXBuilt 1975 · S/N 75-32-159N9505HFinal Approach Aviation LLC · Danville, CABuilt 1975 · S/N 17266185N9505JConnors Paul J II · Murrieta, CABuilt 1966 · S/N 28-3626N9505LClark Gabrial Scott · Humble, TXBuilt 1972 · S/N AA5-0105N9505MLeahy Michael P · Downers Grove, ILBuilt 1966 · S/N 670082N9505PAlways Direct Airways LLC · Indian Trail, NCBuilt 1972 · S/N 24-5022N95063Dugan Jason · Wellington, TXBuilt 1969 · S/N 28-25794N95069Tower Aviation Of Reading Inc · Reading, PABuilt 1969 · S/N 28-25797N9506JEspinal Branhder · Union, NJBuilt 1966 · S/N 28-3627N9506PMcclain Dean L · Torrington, WYBuilt 1972 · S/N 24-5023N9506WAttitude Aviation Inc · Livermore, CABuilt 1997 · S/N 18280110N95071Lund Jonathan J · Glencoe, MNBuilt 1969 · S/N 28-25798N9507DKimball Raymond E · North Bend, ORBuilt 1958 · S/N 22-6422N9507LBatra Sanjeev · Roseville, CABuilt 1986 · S/N 17276566N9507MSanford Russell G · Brooks, GABuilt 1966 · S/N 670084N9507PW K Aviation LLC · Buffalo, SDBuilt 1972 · S/N 24-5024N95080Johnson Patrick W · Toney, ALBuilt 1969 · S/N 28-25800N95084Lyons Nathaniel R · Fort Scott, KSBuilt 1969 · S/N 28-25801N95089Moll Michael J II · Mechanicville, NYBuilt 1969 · S/N 28-25804N9508BRegistered aircraftBuilt 1981 · S/N 172RG0842N9508DLewis Stephen A III · Fleming, GABuilt 1958 · S/N 22-6423N9508JGandas Aero Inc · Eagan, MNS/N 28-3629N9509DMorrison Jim · Grandview, TXBuilt 1958 · S/N 22-6424N9509JStevens Sheldon D · Clark, SDBuilt 1966 · S/N 28-3630N950ACRed Carpet Aviation LLC · Carlsbad, CABuilt 1983 · S/N 17276058N950DRRjc Skyhawk LLC · Middletown, DES/N 17268169N950DSSchmitt Douglas F · Bloomsbury, NJBuilt 1978 · S/N 28R-7837167N950HPKansas Highway Patrol · Topeka, KSBuilt 1998 · S/N 20608002N950MEN950me LLC · Manassas, VABuilt 1976 · S/N 17266539N950MMAngelo Gary P · Jonesboro, ARBuilt 2024 · S/N 016-0950N950TBWeiss Elliott · Fresno, TXBuilt 1980 · S/N 020N950TECrutchfield Randolph E · Scottsdale, AZBuilt 2003 · S/N 10229
Back to AD 87-10-06 R1