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.

N694CRBravo Zulu Aviation Services LLC · Jacksonville, FLBuilt 1978 · S/N 27-7954011N694DBHammond Flying Club Inc · Covington, LABuilt 1975 · S/N 32-7540087N694DCSweet Dixie Aviation LLC · Reddick, FLBuilt 2004 · S/N 3573N694EDLittle Craig · Santa Rosa, CABuilt 1991 · S/N 027N694JSHowell Renny P · Whitehouse, TXS/N 23-1571N694LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881219N694MLLindstrom Micah · Milaca, MNBuilt 2026 · S/N 0001N694MPMohill Loren Dell · Murrieta, CABuilt 2007 · S/N 20821N694PBlack Robert · New Market, ALS/N 2802N694PCBajedi Aviation LLC · Lewes, DEBuilt 2002 · S/N 3257305N694PKRule John H · Statesboro, GABuilt 2022 · S/N 92158N694PSSteger Paul M · Locust Grove, GAS/N 23-1732N694RRiley James L · Lakeville, MNBuilt 2018 · S/N 40191N694RJAtlas 182rj LLC · Port Townsend, WABuilt 2005 · S/N T18208473N694RMTavel Charles · Cave Creek, AZBuilt 2005 · S/N 2843607N694RSSnarr Randy L · South Jordan, UTBuilt 2006 · S/N 105N694SAMile High Ventures Inc · Palm Harbor, FLBuilt 2000 · S/N 18280803N694SMSurveying And Mapping LLC · Austin, TXBuilt 2004 · S/N 20608223N694SPFox Leasing Group LLC · Hollywood, FLBuilt 1999 · S/N 172S8104N694VHall Davis Warren · Mobile, ALBuilt 2003 · S/N 80694N6950BLudwig Henry H · Fort Worth, TXBuilt 1956 · S/N 22-4238N6950DFaught Jeffrey R · Bismarck, NDS/N 22-4879N6950PRegistered aircraftBuilt 1960 · S/N 24-2085N6950RJefferson Airplane LLC · Port Hadlock, WABuilt 1975 · S/N MC-315N6950WEalp LLC · Evansville, INBuilt 1965 · S/N 28-21140N6951PRossback Jason M · Denver, COBuilt 1960 · S/N 24-2086N6952BWesley Jerry A · Moorland, IAS/N 22-4232N6952CSnoz Inc · Sharon, MABuilt 1978 · S/N 28R-7837178N6952HIronfield Jeffrey A · Livermore, CABuilt 1981 · S/N 18267898N6952JLagimoniere Gregory · Jacksonville Beach, FLBuilt 1976 · S/N 28R-7635365N6952PBretts Flying Service LLC · Mount Pleasant, MIS/N 24-2087N6952RMelville Isaiah · Panama City, FLBuilt 1975 · S/N MC-317N6952UDuggan Edwin T · Franklin, MEFirst renewal noticeBuilt 1964 · S/N 322N6952WBeaver Milton H II · Palmer, AKBuilt 1965 · S/N 28-21143N6952YPorterfield Brian B · Wasilla, AKBuilt 1969 · S/N 27-4316N6953DLambert Hubert D Sr · Lincolnton, NCBuilt 1957 · S/N 22-4882N6953JDubois Marcus S · Olive Branch, MSBuilt 1976 · S/N 32R-7680393N6953PCianciolo Philip H · Yakima, WABuilt 1961 · S/N 24-2088N6953QBrancefield John Lewis · Fort Mohave, AZBuilt 1968 · S/N MA-300N6953WScotting David R · Pipestone, MNBuilt 1965 · S/N 28-21144N6954JHughston Thomas Price · NorfolkBuilt 1976 · S/N 32R-7680394N6954PJcav8 LLC · Cartersville, GABuilt 1960 · S/N 24-2090N6954QBalash Bryan J · Oldenburg, INBuilt 1968 · S/N MA-302N6954VGrubb Jefferson D · Chesapeake, VABuilt 1976 · S/N 20-1187N6955DGlover Thomas B · Marana, AZFirst renewal noticeBuilt 1957 · S/N 22-4884N6955YN6955y LLC · Knoxville, IABuilt 1969 · S/N 27-4320N6956BBushplane Lab LLC · Wilderville, ORBuilt 1956 · S/N 22-4237PN6956JJuliet Sky LLC · Sioux City, IABuilt 1976 · S/N 28-7690439N6956QStaab Robert J · Wantage, NJBuilt 1968 · S/N MA-304N6956RMorgan Richard D · Belton, TXBuilt 1975 · S/N MC-320
Back to AD 87-10-06 R1