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.

N8845FDowning Darrell W · Drakesville, IABuilt 1963 · S/N 53-0208N8845JWilliams Daniel · Wallingford, KYBuilt 1965 · S/N 28-2803N88465Castleberry Inc · Ekalaka, MTBuilt 1974 · S/N 791-75N88467Atwood Christopher M · Brownsburg, INBuilt 1974 · S/N 163-75N8846JFighter Pilot Enterprises LLC · Eaton, COBuilt 1965 · S/N 28-2804N8846LN8846l LLC · Homestead, FLBuilt 1971 · S/N 25-5357N8846NDegener William L · Leonard, TXBuilt 1969 · S/N 28-25697N8846PLecrone Gregory S · Granbury, TXBuilt 1965 · S/N 24-4301N8846WMosby Eric M · Tallahassee, FLBuilt 1964 · S/N 28-10397N88473A C E Aviation Inc · Ashton, IDBuilt 1974 · S/N 306-75N88476Bmg Aviation Inc · Bloomington, INBuilt 1974 · S/N 495-75N88477Holland William T III · Midway, ARBuilt 1974 · S/N 136-75N8847CBlumenberg Donald D · Fulton, SDBuilt 1953 · S/N 22-1459N8847FNeitzer Robert W · Milwaukee, WIBuilt 1976 · S/N 28-7725126N8847JFlw LLC · Sandpoint, IDS/N 28-2805N8847MTravel Air LLC · Chico, CABuilt 1964 · S/N TD-575N8847NMcdougal Thomas K · Woodward, OKBuilt 1969 · S/N 28-25699N8847PSouth Texas Weather Modification Association · Pleasanton, TXBuilt 1965 · S/N 24-4302N8847WCitro Michael A · Oakley, CABuilt 1964 · S/N 28-10398N8848JMegaw George C · Fort Lauderdale, FLBuilt 1965 · S/N 28-2806N8848LSoaring Society Of Dayton Inc · Waynesville, OHBuilt 1971 · S/N 25-5359N8848NPro Tech Aviation LLC · Corona, CABuilt 1969 · S/N 28-25700N8848PLazar Stephen D · Toledo, OHBuilt 1965 · S/N 24-4303N8848WHocken David L · Avoca, IABuilt 1964 · S/N 28-10400N8848YBrunot Frank A · Spring Hill, FLBuilt 1969 · S/N 30-1907N88497Airspace Aerial Media LLC · Saint Louis, MOBuilt 1946 · S/N 16121N8849JBailey Aviation Company LLC · Little Rock, ARBuilt 1965 · S/N 28-2807N8849MGuertin Jim B DBA · Lincoln, CABuilt 1969 · S/N 28-11321N8849NCafran Lloyd V · Youngsville, NCBuilt 1969 · S/N 28-25701N8849PCare Management Oregon Inc · New Plymouth, IDBuilt 1965 · S/N 24-4304N8849WAtchison Walter L · Los Alamos, NMBuilt 1964 · S/N 28-10401N884CAColeman Aero Club · Apo AeBuilt 1978 · S/N 17271876N884CCRegistered aircraftBuilt 2001 · S/N 3257221N884DCTanner Greg L · Bend, ORBuilt 1961 · S/N 24-2434N884FTFlorida Institute Of Technology · Melbourne, FLBuilt 2008 · S/N 4496250N884JSCrane John R · Niceville, FLBuilt 1977 · S/N 340-77N884MManning Michael · Bakersfield, CABuilt 2006 · S/N 335N884PSSpainhower Paul Allex · Taylorsville, UTS/N 2318N884RVDannebrock Paul W · Lockport, NYBuilt 2012 · S/N 90884N884SADamico Frank J · Pittsburgh, PABuilt 2003 · S/N 0037N8850NGregs Airplane Rental LLC · Eloy, AZBuilt 1969 · S/N 28-25702N8850PSharp Alan D · Dallas, TXBuilt 1965 · S/N 24-4305N8851JMoore Jeffrey A · Lawrenceburg, TNBuilt 1965 · S/N 28-2815N8851NBloodworth Nathan B · Hendersonville, TNS/N 28-25703N8851PRegistered aircraftBuilt 1965 · S/N 24-4307N8852CWobken Mark E · Orange, CABuilt 1976 · S/N 28R-7635184N8852WSussex Aero Maintenance Inc · Georgetown, DEBuilt 1964 · S/N 28-10405N8852YWikle Luther M · Laceys Spring, ALBuilt 1969 · S/N 39-7N8853CEuropa Aero LLC · Bucyrus, OHBuilt 1976 · S/N 32R-7680141N8853DSlaughter Don Wayne · Farmville, NCBuilt 1958 · S/N 22-6024
Back to AD 87-10-06 R1