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.

N673MALewis University · Romeoville, ILBuilt 1999 · S/N 17280741N673SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881438N673SP673sp LLC · Blaine, MNBuilt 2000 · S/N 172S8633N6740LAslesen Leasin LLC · Halstad, MNBuilt 1974 · S/N 18-7409119N6740NGraham Bruce A · Port Saint Joe, FLBuilt 1968 · S/N 680188N6740UJust Air LLC · Victorville, CABuilt 1963 · S/N 166N6741BPoehler Fred G · Newberg, ORBuilt 1956 · S/N 22-4074N6741LMountain Aviation Corp · Mccall, IDBuilt 1974 · S/N 18-7409121N6741PBall William E · Amarillo, TXBuilt 1960 · S/N 24-1869N6741TCavanaugh Flight Museum · Denison, TXBuilt 1966 · S/N R-172-0127N6742JGannone Nanette V · El Prado, NMBuilt 1968 · S/N 28-24827N6742WMidnight Flight LLC · Wells, TXS/N 28-20863N6743FHollywood Biplane LLC DBA · Atlanta, GABuilt 1976 · S/N 28-7715176N6743HCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1975 · S/N 17265562N6743JStader Noah M · Platteville, WIS/N 28-24459N6743NHollingsworth Michael J · Phoenix, AZBuilt 1968 · S/N 680059N6743PFrancis Sean · Pittstown, NJBuilt 1960 · S/N 24-1871N6744NVan Benschoten Mark T · Linwood, MIBuilt 1968 · S/N 680190N6744PGanton Robert B · San Diego, CAS/N 24-1872N6744UMelia Alexander A · Jacksonville, FLBuilt 1963 · S/N 170N6745JHerget Joshua N · Toulon, ILBuilt 1968 · S/N 28-24462N6745NGonzalez David · Hollywood, FLBuilt 1968 · S/N 680060N6745PPinnacle Aviation Services Inc · Encinitas, CABuilt 1999 · S/N 172S8087N6745UBall Aaron J · Pocatello, IDBuilt 1963 · S/N 2467N6745ZSouthern California Soaring Academy · Valencia, CABuilt 1963 · S/N 25-2360N6746JOn Short Final LLC · Marion, NCBuilt 1968 · S/N 28-24463N6746NOlive City Flying Club Inc · Corning, CABuilt 1968 · S/N 680191N6746PCoppola Marc · Waretown, NJBuilt 1960 · S/N 24-1874N6747HAurora Skyhawks · Portland, ORS/N 17265564N6747NBolt Almos L Jr · Montgomery, TXBuilt 1968 · S/N 680061N6747PWindecker David · Englewood, FLS/N 24-1875N6747UDevuyst Richard C · Pampa, TXBuilt 1963 · S/N 2469N6747WBunn Benjamin D · Winchester, VABuilt 1965 · S/N 28-20871N6748HN6748h LLC · Palm Beach Gardens, FLBuilt 1975 · S/N 17265565N6748NMcneil Scott · Phoenix, AZS/N 680192N6748WCartanian Alfred F · Las Vegas, NVS/N 28-20872N6749BFinke Andy R · North Liberty, INS/N 22-4083N6749JSebesta Roman T · Brazoria, TXBuilt 1968 · S/N 28-24467N6749NFosburgh Kevin J · Las Cruces, NMBuilt 1968 · S/N 680062N6749ZKnutson Wayne R · Tioga, NDBuilt 1963 · S/N 25-2368N674APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843775N674BDStephen G Rogers · Havana, FLBuilt 2011 · S/N 40975N674DTMiller Jeffrey Dale · Brookhaven, GABuilt 1969 · S/N 28R-35074N674DWSunrise Aviation Inc · Ormond Beach, FLBuilt 1999 · S/N 17280772N674ETTaylor Erik A · Montgomery, ILBuilt 1989 · S/N 1934N674FLBackyard Aero LLC · Rockville, INBuilt 1971 · S/N 28-7125602N674FUBlumeshine Logan C · Loveland, COBuilt 2018 · S/N 674RN674LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881684N674MALewis University · Romeoville, ILBuilt 1999 · S/N 17280742N674RGTech Heli LLC · Fort Lauderdale, FLBuilt 1998 · S/N 2885
Back to AD 87-10-06 R1