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.

N6882YFlamingo Air Inc · Cincinnati, OHS/N 27-4231N6883BSlagle Allen E · Newcastle, WYBuilt 1956 · S/N 18-5070N6883JRobbins John L · Crossville, TNS/N 28-7615387N6883NAj Mooney LLC · Port Saint Lucie, FLBuilt 1968 · S/N 680128N6883VHubbell Carl · Crowley, TXBuilt 1975 · S/N 20-1170N6883ZFoster Gary L · Palmer, AKBuilt 1964 · S/N 18-8136N6884HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17265625N6884JHbk Flyers LLC · Alton, ILBuilt 1976 · S/N 28-7690420N6884NLutes Kent A · Tazewell, TNBuilt 1968 · S/N 680157N6884USheaffer Bruce R Jr · Lititz, PABuilt 1963 · S/N 2588N6884VVan Dyck Ryan G · Talent, ORS/N 20-1171N6885HRasmussen Stewart · Santa Barbara, CABuilt 1975 · S/N 17265626N6885NPoskevich Douglas · Deland, FLBuilt 1968 · S/N 680158N6885UGranier Bernie C Trustee · Bandera, TXBuilt 1963 · S/N 2589N6885WMiller Andy D · Marana, AZS/N 28-21041N6886BOhmans Inc · Gillette, WYBuilt 1956 · S/N 18-5073N6886HParr Larry · Clarksville, TNBuilt 1975 · S/N 17265627N6886JFlanders David J · Madison, WIBuilt 1976 · S/N 28-7690421N6886NSibille Keith Curtis · Griffin, GABuilt 1968 · S/N 680129N6886PBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 24-2022N6886UN6886u Inc · Tucson, AZBuilt 1963 · S/N 2590N6886WGregory Joshua L · Oxford, MSBuilt 1965 · S/N 28-21042N6887JBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 32R-7680379N6887NColton Frank Lasusa · Harrisburg, PABuilt 1968 · S/N 680159N6887UAce Aircraft Leasing Inc · Nazareth, PABuilt 1963 · S/N 2591N6888BVenell Farms Inc · Corvallis, ORBuilt 1956 · S/N 18-5076N6888DCenter Charles C · Wasilla, AKBuilt 2005 · S/N 101-1N6888FAtlanta Peach Air LLC · Oxford, GAS/N 32R-7780049N6888HN6888h LLC · Wayne, NJS/N 17265628N6888JMovable Air LLC · Oldsmar, FLBuilt 1976 · S/N 32R-7680380N6888NGrass James Conrad · Phoenix, AZS/N 680160N6888PKempf Douglas A · La Center, WABuilt 1960 · S/N 24-2025N6888WAnderson Ty M · Grenada, MSBuilt 1965 · S/N 28-21045N6888YFlying W Leasing Inc · Bartlett, ILBuilt 1969 · S/N 27-4240N688AGrasky Endurance Coaching LLC · Tucson, AZS/N 32R7887184N688BGJones William E · Birmingham, ALBuilt 1969 · S/N 28R-35023N688CABetter Southlake Properties LLC · Pagosa Springs, COS/N 17262505N688HZumbrun Dennis L · Montz, LABuilt 1993 · S/N 2341N688KKing William K · Rockwall, TXBuilt 2016 · S/N 40620N688LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881267N688MBHill Frank G · Navarre, FLBuilt 1965 · S/N 24-4231N688NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2014 · S/N 4496374N688PAJoe P Fassio · Union, WABuilt 1953 · S/N 25535N688RMBurton Jason S · Howell, MIBuilt 1967 · S/N 670272N688TAircapital Nevada Inc · Carson City, NVBuilt 1958 · S/N TD-75N6890Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1978 · S/N 31-7812003N6890LTop Tier Truck And Trailer LLC · Dimmitt, TXBuilt 1981 · S/N 6108708162156N6890PMarble Jere D · Dayton, NVBuilt 1960 · S/N 24-2027N6890RBudgeon Mark K · Mandeville, LABuilt 1990 · S/N 195690N6890WRegistered aircraftS/N 28-21047
Back to AD 87-10-06 R1