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.

N82813Preside Management Inc · Coachella, CABuilt 1980 · S/N 32-8124001N8281CThomas Ken C · Fairbanks, AKBuilt 1954 · S/N 18-3689N8281EAir Plains Services Corp · Wellington, KSBuilt 1979 · S/N 17272168N8281JJudy Gregory K · Hudson Oaks, TXBuilt 1979 · S/N VAC-127-79N8281NTan Dexter E · Dallas, TXS/N 28-25497N8281PDubois Jean-Claude · Midlothian, TXS/N 24-3533N8281WNeisen Brandon L · Fowler, ILBuilt 1965 · S/N 28-2438N8281YReined Out LLC · Nantucket, MABuilt 1980 · S/N 328106003N82829Wingin It 13 LLC · Middletown, NYBuilt 1980 · S/N 28-8111015N8282JHoover Michael B · Ridgeland, WIBuilt 1979 · S/N VAC-128-79N8282KNoyes Tony · Lewisville, TXS/N 32R-8129002N8282NMercury Aircraft Holdings Inc · West Monroe, LABuilt 1980 · S/N 32R-8129003N8282VEnsemble Air LLC · Laramie, WYBuilt 1980 · S/N 28-8116060N8282WBenker Albert J · Bevier, MOBuilt 1965 · S/N 28-2440N82832Stokke Todd · Magnolia, TXBuilt 1980 · S/N 28-8190066N82836Aerodreams Aviation LLC · Raleigh, NCBuilt 1980 · S/N 28-8190071N8283BFatiha Anouar · Columbus, INBuilt 1980 · S/N 28-8111016N8283JFurey Gale J · Bedford, NHBuilt 1979 · S/N VAC-129-79N8283NRuth Joyce Aviation LLC · Henderson, TXBuilt 1969 · S/N 28-25499N8283PPolzin Thomas H · Chippewa Falls, WIBuilt 1963 · S/N 24-3535N8283VMiloud Chadd K · Fort Worth, TXBuilt 1980 · S/N 28-8116065N8283YPhillips Thaddus L · Knoxville, TNBuilt 1980 · S/N 28-8190064N8284JCrouch Scott M · Steamboat Springs, COBuilt 1979 · S/N VAC-130-79N8284NHolland Alan L · Houston, TXBuilt 1969 · S/N 28-25501N8284PTonry Richard Martin · Georgetown, TXBuilt 1963 · S/N 24-3536N8284WCaldwell Darrel R · Panama City Beach, FLBuilt 1965 · S/N 28-2443N8284YKahnke Richard Joseph · Mankato, MNBuilt 1980 · S/N 28-8111019N82859Schoeler George A · Ocala, FLBuilt 1980 · S/N 28R-8118018N8285BHyldburg Aviation Inc · Plymouth, MABuilt 1980 · S/N 28-8116066N8285EJames G Loy General Contractor Inc · Punta Gorda, FLBuilt 1979 · S/N 17272171N8285PPhillips Dale J · Michigan City, INBuilt 1963 · S/N 24-3537N8285WBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 28-2446N8285YAmerican Aviation Inc · Woods Cross, UTFirst renewal noticeBuilt 1980 · S/N 28-8190073N82864Meyer Fredric Kim · Orange, CABuilt 1982 · S/N 28-8316005N8286CMidwest Sky Chasers Nfp · Algonquin, ILBuilt 1975 · S/N 28-7690110N8286EPreston Richard R Trustee · Albuquerque, NMBuilt 1979 · S/N 17272172N8286NAyyildiz Erol · Glen Rock, NJBuilt 1969 · S/N 28-25503N8286PStage Crew LLC · Clermont, FLBuilt 1963 · S/N 24-3538N8286RHuhnke John F · Newburgh, INBuilt 1999 · S/N 103N8286YCoub Industries Inc · Fairfield, CABuilt 1967 · S/N 30-1422N8287Holloway Earnie G · Bonner Springs, KSBuilt 1972 · S/N 5231931N8287BCostanti Nicolas J · Medford, ORS/N 18-7609048N8287JBurnett Stephen B · Granby, MOBuilt 1979 · S/N VAC-133-79N8287NBetik Patrick G · Grapevine, TXS/N 28-25504N8287PDeviny William M Jr · Arroyo Grande, CABuilt 1963 · S/N 24-3539N8287RHuhnke John · Newburgh, INBuilt 1972 · S/N 32-81N8287YLocust Hill Aviation LLC · Lewes, DEBuilt 1980 · S/N 28-8111020N8288AJohnson Carmen · White Cloud, MIBuilt 1982 · S/N 28-8390020N8288CRood James D · Winston, NMBuilt 1955 · S/N 18-4113N8288EGomez Cierra D · Jasper, ALS/N 17272174
Back to AD 87-10-06 R1